PQH Budget Period Position Detail

Description
Categories: BI Publisher
Columns: 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 ...
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
Effective Date
 
Date
Budget Name
 
LOV Oracle
Record Type
 
LOV Oracle
P_business_group_id
 
Number