PQH Position Element Summary

Description
Categories: BI Publisher
Imported from BI Publisher
Application: Public Sector HR
Source: Position Element Summary Report (XML)
Short Name: PQHWSEPS_XML
DB package: PQH_PQHWSEPS_XMLP_PKG
Run PQH Position Element Summary and other Oracle EBS reports with Blitz Report™ on our demo environment
select element_name,
      element_type_id,
       position_name, 
       budget_measurement_type, 
       budget_unit_id, 
       pqh_mgmt_rpt_pkg.get_posn_element_bdgt_amt
       (
        null,
        position_id,
        element_type_id,
        :p_start_date,
        :p_end_date,
        budget_unit_id,
:p_currency_code
       )  budgeted_amt,
       pqh_mgmt_rpt_pkg.get_posn_elmnt_actual_cmmtmnts
       (
        null,
        position_id,
        element_type_id,
        :p_start_date,
        :p_end_date,
        budget_unit_id,
        'C',
:p_currency_code
       )  committed_amt,
       pqh_mgmt_rpt_pkg.get_posn_elmnt_actual_cmmtmnts
       (
        null,
        position_id,
        element_type_id,
        :p_start_date,
        :p_end_date,
        budget_unit_id,
        'A',
:p_currency_code
       )  actual_amt, 
	PQH_PQHWSEPS_XMLP_PKG.cf_act_performula(pqh_mgmt_rpt_pkg.get_posn_element_bdgt_amt ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ), pqh_mgmt_rpt_pkg.get_posn_elmnt_actual_cmmtmnts ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'A' , :p_currency_code )) CF_act_per, 
	PQH_PQHWSEPS_XMLP_PKG.cf_com_performula(pqh_mgmt_rpt_pkg.get_posn_element_bdgt_amt ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ), pqh_mgmt_rpt_pkg.get_posn_elmnt_actual_cmmtmnts ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'C' , :p_currency_code )) CF_com_per, 
	PQH_PQHWSEPS_XMLP_PKG.cf_1formula(budget_unit_id, pqh_mgmt_rpt_pkg.get_posn_elmnt_actual_cmmtmnts ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'A' , :p_currency_code ), pqh_mgmt_rpt_pkg.get_posn_elmnt_actual_cmmtmnts ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'C' , :p_currency_code )) cf_projected_exp, 
	PQH_PQHWSEPS_XMLP_PKG.cf_proj_performula(pqh_mgmt_rpt_pkg.get_posn_element_bdgt_amt ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ), PQH_PQHWSEPS_XMLP_PKG.cf_1formula(budget_unit_id, pqh_mgmt_rpt_pkg.get_posn_elmnt_actual_cmmtmnts ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'A' , :p_currency_code ), pqh_mgmt_rpt_pkg.get_posn_elmnt_actual_cmmtmnts ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'C' , :p_currency_code ))) CF_proj_per, 
	PQH_PQHWSEPS_XMLP_PKG.cf_def_ex_amtformula(pqh_mgmt_rpt_pkg.get_posn_element_bdgt_amt ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ), PQH_PQHWSEPS_XMLP_PKG.cf_1formula(budget_unit_id, pqh_mgmt_rpt_pkg.get_posn_elmnt_actual_cmmtmnts ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'A' , :p_currency_code ), pqh_mgmt_rpt_pkg.get_posn_elmnt_actual_cmmtmnts ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'C' , :p_currency_code ))) cf_def_ex_amt, 
	PQH_PQHWSEPS_XMLP_PKG.cf_def_ex_performula(pqh_mgmt_rpt_pkg.get_posn_element_bdgt_amt ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ), PQH_PQHWSEPS_XMLP_PKG.cf_def_ex_amtformula(pqh_mgmt_rpt_pkg.get_posn_element_bdgt_amt ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , :p_currency_code ), PQH_PQHWSEPS_XMLP_PKG.cf_1formula(budget_unit_id, pqh_mgmt_rpt_pkg.get_posn_elmnt_actual_cmmtmnts ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'A' , :p_currency_code ), pqh_mgmt_rpt_pkg.get_posn_elmnt_actual_cmmtmnts ( null , position_id , element_type_id , :p_start_date , :p_end_date , budget_unit_id , 'C' , :p_currency_code )))) CF_def_ex_per, 
	PQH_PQHWSEPS_XMLP_PKG.cf_format_mask1(budget_unit_id) CF_Format_Mask1
from 	pqh_position_element_types_v
where 	element_type_id = :p_element_type_id
And 	pqh_mgmt_rpt_pkg.check_pos_type_and_variance
                  (   null, 		position_id,
                     :p_start_date,              :p_end_date,
                      budget_unit_id ,	:p_position_type,
	   NVL(:p_variance_percent,0)   , :p_currency_code    ) =  NVL(:p_position_type,'A')
Parameter Name SQL text Validation
Effective Date
 
Date
Element Name
 
LOV Oracle
Position Type
 
LOV Oracle
Variance Percent
 
Number
Start Date
 
Date
End Date
 
Date
Currency
 
LOV Oracle