PQH Position Summary

➜ Back to Library
Description
Categories: BI Publisher
Imported from BI Publisher
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')
Parameter Name SQL text Validation
Effective Date 
 
 Date
Organization Name 
 
 LOV Oracle
Position Type 
 
 LOV Oracle
Variance Percent 
 
 Number
Start Date 
 
 Date
End Date 
 
 Date
Currency 
 
 LOV Oracle
Download
Related Blitz Reports
PQH Position Element Detail PQH Budget Period Position Detail PQH Position Element Summary PQH Entity Element Summary PQH Organizational Position Summary PQH IPEDS Report - Employees By Assigned Position (EAP) - Part A(obsoleted) PQH IPEDS Report - Employees By Assigned Position (EAP) - Part B(obsoleted) PQH EEO5 Reporting OTA Budget and Cost Reconciliation
Blitz Report™

Blitz Report™ provides multiple benefits: