PQH Organizational Position Summary

Description
Categories: BI Publisher
Columns: Bgrp Business Group Id, Bgrp Budget Measure Type, Bgrp Budget Unit Id, Bgrp Budgeted Amt, Bgrp Actual Amt, Bgrp Committed Amt, Cf Bgrp Projected Amt, Cf Bgrp Def Ex Amt, Cf Bgrp Com Per, Cf Bgrp Proj Per ...
Application: Public Sector HR
Source: Organizational Position Summary Report (XML)
Short Name: PQHWSPCH_XML
DB package: PQH_PQHWSPCH_XMLP_PKG
Select        business_group_id		bgrp_business_group_id,
	budget_measurement_type	bgrp_budget_measure_type, 
        	budget_unit_id		bgrp_budget_unit_id,
	NVL(pqh_mgmt_rpt_pkg.get_bgrp_posn_budget_amt  (
	           business_group_id,           :p_start_date,
	           :p_end_date,           budget_unit_id, :p_currency_code       ),0)	bgrp_budgeted_amt,	
	NVL(pqh_mgmt_rpt_pkg.get_bgrp_posn_actual_cmmtmnts       (
	        business_group_id,        :p_start_date,
	        :p_end_date,        budget_unit_id,        'A', :p_currency_code       ) ,0)	bgrp_actual_amt,
	NVL(pqh_mgmt_rpt_pkg.get_bgrp_posn_actual_cmmtmnts    (
	        business_group_id,        :p_start_date,
	        :p_end_date,        budget_unit_id,        'C' , :p_currency_code      ),0) 	bgrp_committed_amt, 
	PQH_PQHWSPCH_XMLP_PKG.cf_bgrp_budgeted_amtformula(budget_unit_id, NVL ( pqh_mgmt_rpt_pkg.get_bgrp_posn_actual_cmmtmnts ( business_group_id , :p_start_date , :p_end_date , budget_unit_id , 'A' , :p_currency_code ) , 0 ), NVL ( pqh_mgmt_rpt_pkg.get_bgrp_posn_actual_cmmtmnts ( business_group_id , :p_start_date , :p_end_date , budget_unit_id , 'C' , :p_currency_code ) , 0 )) CF_bgrp_projected_amt, 
	PQH_PQHWSPCH_XMLP_PKG.cf_bgrp_def_ex_amtformula(NVL ( pqh_mgmt_rpt_pkg.get_bgrp_posn_budget_amt ( business_group_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ) , 0 ), PQH_PQHWSPCH_XMLP_PKG.cf_bgrp_budgeted_amtformula(budget_unit_id, NVL ( pqh_mgmt_rpt_pkg.get_bgrp_posn_actual_cmmtmnts ( business_group_id , :p_start_date , :p_end_date , budget_unit_id , 'A' , :p_currency_code ) , 0 ), NVL ( pqh_mgmt_rpt_pkg.get_bgrp_posn_actual_cmmtmnts ( business_group_id , :p_start_date , :p_end_date , budget_unit_id , 'C' , :p_currency_code ) , 0 ))) CF_bgrp_def_ex_amt, 
	PQH_PQHWSPCH_XMLP_PKG.cf_bgrp_com_performula(NVL ( pqh_mgmt_rpt_pkg.get_bgrp_posn_budget_amt ( business_group_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ) , 0 ), NVL ( pqh_mgmt_rpt_pkg.get_bgrp_posn_actual_cmmtmnts ( business_group_id , :p_start_date , :p_end_date , budget_unit_id , 'C' , :p_currency_code ) , 0 )) CF_bgrp_com_per, 
	PQH_PQHWSPCH_XMLP_PKG.cf_bgrp_proj_performula(NVL ( pqh_mgmt_rpt_pkg.get_bgrp_posn_budget_amt ( business_group_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ) , 0 ), PQH_PQHWSPCH_XMLP_PKG.cf_bgrp_budgeted_amtformula(budget_unit_id, NVL ( pqh_mgmt_rpt_pkg.get_bgrp_posn_actual_cmmtmnts ( business_group_id , :p_start_date , :p_end_date , budget_unit_id , 'A' , :p_currency_code ) , 0 ), NVL ( pqh_mgmt_rpt_pkg.get_bgrp_posn_actual_cmmtmnts ( business_group_id , :p_start_date , :p_end_date , budget_unit_id , 'C' , :p_currency_code ) , 0 ))) CF_bgrp_proj_per, 
	PQH_PQHWSPCH_XMLP_PKG.cf_format_mask3(budget_unit_id) CF_Format_Mask3, 
	PQH_PQHWSPCH_XMLP_PKG.cf_bgrp_def_ex_performula(NVL ( pqh_mgmt_rpt_pkg.get_bgrp_posn_budget_amt ( business_group_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ) , 0 ), PQH_PQHWSPCH_XMLP_PKG.cf_bgrp_def_ex_amtformula(NVL ( pqh_mgmt_rpt_pkg.get_bgrp_posn_budget_amt ( business_group_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ) , 0 ), PQH_PQHWSPCH_XMLP_PKG.cf_bgrp_budgeted_amtformula(budget_unit_id, NVL ( pqh_mgmt_rpt_pkg.get_bgrp_posn_actual_cmmtmnts ( business_group_id , :p_start_date , :p_end_date , budget_unit_id , 'A' , :p_currency_code ) , 0 ), NVL ( pqh_mgmt_rpt_pkg.get_bgrp_posn_actual_cmmtmnts ( business_group_id , :p_start_date , :p_end_date , budget_unit_id , 'C' , :p_currency_code ) , 0 )))) CF_bgrp_def_ex_per, 
	PQH_PQHWSPCH_XMLP_PKG.cf_bgrp_actual_performula(NVL ( pqh_mgmt_rpt_pkg.get_bgrp_posn_budget_amt ( business_group_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ) , 0 ), NVL ( pqh_mgmt_rpt_pkg.get_bgrp_posn_actual_cmmtmnts ( business_group_id , :p_start_date , :p_end_date , budget_unit_id , 'A' , :p_currency_code ) , 0 )) CF_bgrp_actual_per
from 	pqh_pc_org_summary_v 
 where business_group_id=:business_group_id
group by 	business_group_id, 
	budget_measurement_type, budget_unit_id
Parameter Name SQL text Validation
Effective Date
 
Date
Position Type
 
LOV Oracle
Variance Percent
 
Number
Start Date
 
Date
End Date
 
Date
Currency
 
LOV Oracle
Business Group
 
Number