PQH Organizational Position Summary

Description
Categories: BI Publisher, Human Resources
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
Business Group
 
Number
Currency
 
LOV Oracle
End Date
 
Date
Start Date
 
Date
Variance Percent
 
Number
Position Type
 
LOV Oracle
Effective Date
 
Date