PQH Position Element Detail

Description
Categories: BI Publisher, Human Resources
Application: Public Sector HR
Source: Position Element Detail Report (XML)
Short Name: PQHWSPBD_XML
DB package: PQH_PQHWSPBD_XMLP_PKG
select organization_name,
       position_name,
       budget_measurement_type, 
       element_name,
      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_PQHWSPBD_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_PQHWSPBD_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_PQHWSPBD_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_PQHWSPBD_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_PQHWSPBD_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_PQHWSPBD_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_PQHWSPBD_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_PQHWSPBD_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_PQHWSPBD_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_PQHWSPBD_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_PQHWSPBD_XMLP_PKG.cf_format_mask(budget_unit_id) CF_Format_Mask
from pqh_position_budgets_v
where position_id = NVL(:p_position_id,position_id)
  and organization_id = NVL(:p_organization_id,organization_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
P_business_group_id
 
Number
Currency
 
LOV Oracle
End Date
 
Date
Start Date
 
Date
Variance Percent
 
Number
Position Type
 
LOV Oracle
Position Name
 
LOV Oracle
Organization Name
 
LOV Oracle
Effective Date
 
Date