PQH Position Summary

Description
Categories: BI Publisher, Human Resources
Application: Public Sector HR
Source: Position Summary Report (XML)
Short Name: PQHWSOPS_XML
DB package: PQH_PQHWSOPS_XMLP_PKG
select organization_name,
      organization_id organization_id1_parent,
       position_name, 
       budget_measurement_type, 
      budget_unit_id,
       pqh_mgmt_rpt_pkg.get_position_budget_amt
       (
        null,
        position_id,
        :p_start_date_1,
        :p_end_date_1,
        budget_unit_id,
       :p_currency_code
       )  budgeted_amt,
       pqh_mgmt_rpt_pkg.get_position_actual_cmmtmnts
       (
        null,
        position_id,
        :p_start_date_1,
        :p_end_date_1,
        budget_unit_id,
        'C',
    :p_currency_code
       )  committed_amt,
       pqh_mgmt_rpt_pkg.get_position_actual_cmmtmnts
       (
        null,
        position_id,
        :p_start_date_1,
        :p_end_date_1,
        budget_unit_id,
        'A',
     :p_currency_code
       )  actual_amt, 
	PQH_PQHWSOPS_XMLP_PKG.cf_act_performula(pqh_mgmt_rpt_pkg.get_position_budget_amt ( null , position_id , :p_start_date_1 , :p_end_date_1 , budget_unit_id , :p_currency_code ), pqh_mgmt_rpt_pkg.get_position_actual_cmmtmnts ( null , position_id , :p_start_date_1 , :p_end_date_1 , budget_unit_id , 'A' , :p_currency_code )) CF_act_per, 
	PQH_PQHWSOPS_XMLP_PKG.cf_com_performula(pqh_mgmt_rpt_pkg.get_position_budget_amt ( null , position_id , :p_start_date_1 , :p_end_date_1 , budget_unit_id , :p_currency_code ), pqh_mgmt_rpt_pkg.get_position_actual_cmmtmnts ( null , position_id , :p_start_date_1 , :p_end_date_1 , budget_unit_id , 'C' , :p_currency_code )) CF_com_per, 
	PQH_PQHWSOPS_XMLP_PKG.cf_1formula(budget_unit_id, pqh_mgmt_rpt_pkg.get_position_actual_cmmtmnts ( null , position_id , :p_start_date_1 , :p_end_date_1 , budget_unit_id , 'A' , :p_currency_code ), pqh_mgmt_rpt_pkg.get_position_actual_cmmtmnts ( null , position_id , :p_start_date_1 , :p_end_date_1 , budget_unit_id , 'C' , :p_currency_code )) cf_projected_exp, 
	PQH_PQHWSOPS_XMLP_PKG.cf_proj_performula(pqh_mgmt_rpt_pkg.get_position_budget_amt ( null , position_id , :p_start_date_1 , :p_end_date_1 , budget_unit_id , :p_currency_code ), PQH_PQHWSOPS_XMLP_PKG.cf_1formula(budget_unit_id, pqh_mgmt_rpt_pkg.get_position_actual_cmmtmnts ( null , position_id , :p_start_date_1 , :p_end_date_1 , budget_unit_id , 'A' , :p_currency_code ), pqh_mgmt_rpt_pkg.get_position_actual_cmmtmnts ( null , position_id , :p_start_date_1 , :p_end_date_1 , budget_unit_id , 'C' , :p_currency_code ))) CF_proj_per, 
	PQH_PQHWSOPS_XMLP_PKG.cf_def_ex_amtformula(pqh_mgmt_rpt_pkg.get_position_budget_amt ( null , position_id , :p_start_date_1 , :p_end_date_1 , budget_unit_id , :p_currency_code ), PQH_PQHWSOPS_XMLP_PKG.cf_1formula(budget_unit_id, pqh_mgmt_rpt_pkg.get_position_actual_cmmtmnts ( null , position_id , :p_start_date_1 , :p_end_date_1 , budget_unit_id , 'A' , :p_currency_code ), pqh_mgmt_rpt_pkg.get_position_actual_cmmtmnts ( null , position_id , :p_start_date_1 , :p_end_date_1 , budget_unit_id , 'C' , :p_currency_code ))) cf_def_ex_amt, 
	PQH_PQHWSOPS_XMLP_PKG.cf_def_ex_performula(pqh_mgmt_rpt_pkg.get_position_budget_amt ( null , position_id , :p_start_date_1 , :p_end_date_1 , budget_unit_id , :p_currency_code ), PQH_PQHWSOPS_XMLP_PKG.cf_def_ex_amtformula(pqh_mgmt_rpt_pkg.get_position_budget_amt ( null , position_id , :p_start_date_1 , :p_end_date_1 , budget_unit_id , :p_currency_code ), PQH_PQHWSOPS_XMLP_PKG.cf_1formula(budget_unit_id, pqh_mgmt_rpt_pkg.get_position_actual_cmmtmnts ( null , position_id , :p_start_date_1 , :p_end_date_1 , budget_unit_id , 'A' , :p_currency_code ), pqh_mgmt_rpt_pkg.get_position_actual_cmmtmnts ( null , position_id , :p_start_date_1 , :p_end_date_1 , budget_unit_id , 'C' , :p_currency_code )))) CF_def_ex_per, 
	PQH_PQHWSOPS_XMLP_PKG.cf_format_mask2(budget_unit_id) CF_Format_Mask2
from pqh_organization_budgets_v
where organization_id = :p_organization_id_1
And pqh_mgmt_rpt_pkg.check_pos_type_and_variance
                  (   null, 		position_id,
                     :p_start_date_1,              :p_end_date_1,
                      budget_unit_id ,	:p_position_type,
	   NVL(:p_variance_percent,0)  ,:p_currency_code) = NVL(:p_position_type,'A')
Ask a question
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
Organization Name
 
LOV Oracle
Effective Date
 
Date