PQH Position Element Detail

Description
Categories: BI Publisher
Columns: Organization Name, Position Name, Budget Measurement Type, Element Name, Budget Unit Id, Budgeted Amt, Committed Amt, Actual Amt, Cf Act Per, Cf Com Per ...
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
Effective Date
 
Date
Organization Name
 
LOV Oracle
Position Name
 
LOV Oracle
Position Type
 
LOV Oracle
Variance Percent
 
Number
Start Date
 
Date
End Date
 
Date
Currency
 
LOV Oracle
P_business_group_id
 
Number