PQH Entity Element Summary

Description
Categories: BI Publisher, Human Resources
Application: Public Sector HR
Source: Entity Element Summary Report (XML)
Short Name: PQHWSEES_XML
DB package: PQH_PQHWSEES_XMLP_PKG
select element_name  ELEMENT_NAME_A,								  
      element_type_id  ELEMENT_TYPE_ID_A,								  
       entity_name position_name, 						  
       budget_measurement_type, 						  
       budget_unit_id,      							  
       pqh_mgmt_rpt_pkg.get_ent_element_bdgt_amt				  
       (									  
        null,									  
        budgeted_entity_cd,							  
        entity_id,								  
        element_type_id,							  
        :p_start_date,								  
        :p_end_date,								  
        budget_unit_id,								  
:p_currency_code								  
       )  budgeted_amt,								  
       pqh_mgmt_rpt_pkg.get_ent_elmnt_actual_cmmtmnts				  
       (									  
        null,									  
       budgeted_entity_cd,							  
        entity_id,								  
        element_type_id,							  
        :p_start_date,								  
        :p_end_date,								  
        budget_unit_id,								  
        'C',									  
:p_currency_code								  
       )  committed_amt,							  
       pqh_mgmt_rpt_pkg.get_ent_elmnt_actual_cmmtmnts				  
       (									  
        null,									  
      budgeted_entity_cd,							  
        entity_id,								  
        element_type_id,							  
        :p_start_date,								  
        :p_end_date,								  
        budget_unit_id,								  
        'A',									  
:p_currency_code								  
       )  actual_amt, 
	PQH_PQHWSEES_XMLP_PKG.cf_act_performula(pqh_mgmt_rpt_pkg.get_ent_element_bdgt_amt ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ), pqh_mgmt_rpt_pkg.get_ent_elmnt_actual_cmmtmnts ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'A' , :p_currency_code )) CF_act_per, 
	PQH_PQHWSEES_XMLP_PKG.cf_com_performula(pqh_mgmt_rpt_pkg.get_ent_element_bdgt_amt ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ), pqh_mgmt_rpt_pkg.get_ent_elmnt_actual_cmmtmnts ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'C' , :p_currency_code )) CF_com_per, 
	PQH_PQHWSEES_XMLP_PKG.cf_1formula(budget_unit_id, pqh_mgmt_rpt_pkg.get_ent_elmnt_actual_cmmtmnts ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'A' , :p_currency_code ), pqh_mgmt_rpt_pkg.get_ent_elmnt_actual_cmmtmnts ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'C' , :p_currency_code )) cf_projected_exp, 
	PQH_PQHWSEES_XMLP_PKG.cf_proj_performula(pqh_mgmt_rpt_pkg.get_ent_element_bdgt_amt ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ), PQH_PQHWSEES_XMLP_PKG.cf_1formula(budget_unit_id, pqh_mgmt_rpt_pkg.get_ent_elmnt_actual_cmmtmnts ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'A' , :p_currency_code ), pqh_mgmt_rpt_pkg.get_ent_elmnt_actual_cmmtmnts ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'C' , :p_currency_code ))) CF_proj_per, 
	PQH_PQHWSEES_XMLP_PKG.cf_def_ex_amtformula(pqh_mgmt_rpt_pkg.get_ent_element_bdgt_amt ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ), PQH_PQHWSEES_XMLP_PKG.cf_1formula(budget_unit_id, pqh_mgmt_rpt_pkg.get_ent_elmnt_actual_cmmtmnts ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'A' , :p_currency_code ), pqh_mgmt_rpt_pkg.get_ent_elmnt_actual_cmmtmnts ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'C' , :p_currency_code ))) cf_def_ex_amt, 
	PQH_PQHWSEES_XMLP_PKG.cf_def_ex_performula(pqh_mgmt_rpt_pkg.get_ent_element_bdgt_amt ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ), PQH_PQHWSEES_XMLP_PKG.cf_def_ex_amtformula(pqh_mgmt_rpt_pkg.get_ent_element_bdgt_amt ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ), PQH_PQHWSEES_XMLP_PKG.cf_1formula(budget_unit_id, pqh_mgmt_rpt_pkg.get_ent_elmnt_actual_cmmtmnts ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'A' , :p_currency_code ), pqh_mgmt_rpt_pkg.get_ent_elmnt_actual_cmmtmnts ( null , budgeted_entity_cd , entity_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'C' , :p_currency_code )))) CF_def_ex_per, 
	PQH_PQHWSEES_XMLP_PKG.cf_format_mask1(budget_unit_id) CF_Format_Mask1
from 	pqh_entity_element_types_v						  
where 	element_type_id = :p_element_type_id					  
And    budgeted_entity_cd = :p_budgeted_entity_cd
And 	pqh_mgmt_rpt_pkg.check_ent_type_and_variance				  
      (   null, 	:p_budgeted_entity_cd,	entity_id,			  
	 :p_start_date,              :p_end_date,				  
	  budget_unit_id ,	:p_entity_type,					  
NVL(:p_variance_percent,0)   , :p_currency_code    ) =  NVL(:p_entity_type,'A')
order by 1,3,5
Parameter Name SQL text Validation
Business Group
 
Number
Currency
 
LOV Oracle
End Date
 
Date
Start Date
 
Date
Variance Percent
 
Number
Entity Type
 
LOV Oracle
Entity
 
LOV Oracle
Element Name
 
LOV Oracle
Effective Date
 
Date