PQH Budget Period Position Detail

Description
Categories: BI Publisher, Human Resources
Application: Public Sector HR
Source: Budget Period Position Detail Report (XML)
Short Name: PQHWSBPR_XML
DB package: PQH_PQHWSBPR_XMLP_PKG
select budget_name,
       budgeted_entity,
       budget_style,
       budget_calendar_name,
       budget_calendar_frequency,
       budget_start_date,
       budget_end_date,
       budget_version_number,
       budget_version_start_date,
       budget_version_end_date,
       position_name, 
       budget_measurement_type, 
       budget_period_name,
       budget_period_budgeted_value,
       budget_period_cmmtmnt_value,
       budget_period_actual_value,
       budget_unit_Id,
       pqh_mgmt_rpt_pkg.get_pos_org(position_id) Organization_name, 
	PQH_PQHWSBPR_XMLP_PKG.cf_act_performula(budget_period_budgeted_value, budget_period_actual_value) CF_act_per, 
	PQH_PQHWSBPR_XMLP_PKG.cf_com_performula(budget_period_budgeted_value, budget_period_cmmtmnt_value) CF_com_per, 
	PQH_PQHWSBPR_XMLP_PKG.cf_1formula(budget_unit_Id, budget_period_actual_value, budget_period_cmmtmnt_value) cf_projected_exp, 
	PQH_PQHWSBPR_XMLP_PKG.cf_proj_performula(budget_period_budgeted_value, PQH_PQHWSBPR_XMLP_PKG.cf_1formula(budget_unit_Id, budget_period_actual_value, budget_period_cmmtmnt_value)) CF_proj_per, 
	PQH_PQHWSBPR_XMLP_PKG.cf_def_ex_amtformula(budget_period_budgeted_value, PQH_PQHWSBPR_XMLP_PKG.cf_1formula(budget_unit_Id, budget_period_actual_value, budget_period_cmmtmnt_value)) cf_def_ex_amt, 
	PQH_PQHWSBPR_XMLP_PKG.cf_format_maskformula(budget_unit_Id) CF_format_mask, 
	PQH_PQHWSBPR_XMLP_PKG.cf_def_ex_performula(budget_period_budgeted_value, PQH_PQHWSBPR_XMLP_PKG.cf_def_ex_amtformula(budget_period_budgeted_value, PQH_PQHWSBPR_XMLP_PKG.cf_1formula(budget_unit_Id, budget_period_actual_value, budget_period_cmmtmnt_value))) CF_def_ex_per
from pqh_budget_details_v
where budget_version_id = :p_budget_version_id
and (:p_record_type='A' or  budget_period_budgeted_value is not null)
Parameter Name SQL text Validation
P_business_group_id
 
Number
Record Type
 
LOV Oracle
Budget Name
 
LOV Oracle
Effective Date
 
Date