PER Staffing Budget Details
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Staffing Budget Details
Application: Human Resources
Source: Staffing Budget Details Report (XML)
Short Name: PERRPRBD_XML
DB package: PER_PERRPRBD_XMLP_PKG
Description: Staffing Budget Details
Application: Human Resources
Source: Staffing Budget Details Report (XML)
Short Name: PERRPRBD_XML
DB package: PER_PERRPRBD_XMLP_PKG
Run
PER Staffing Budget Details and other Oracle EBS reports with Blitz Report™ on our demo environment
select tim.period_name period, tim.start_date start_date, tim.end_date end_date, bva.value budget_value, bva.budget_element_id budget_element_id1, PER_PERRPRBD_XMLP_PKG.c_start_valueformula(:ORGANIZATION_ID, :JOB_ID, :POSITION_ID, :GRADE_ID, tim.start_date, tim.end_date, bva.value) C_start_value, PER_PERRPRBD_XMLP_PKG.C_end_value_p C_end_value, PER_PERRPRBD_XMLP_PKG.C_amount_p C_amount, PER_PERRPRBD_XMLP_PKG.C_percentage_p C_percentage from per_budget_values bva, per_time_periods tim where tim.time_period_id = bva.time_period_id and tim.start_date >= (select tim2.start_date from per_time_periods tim2 where tim2.time_period_id = :p_start_time_period_id) and tim.end_date <= (select tim3.end_date from per_time_periods tim3 where tim3.time_period_id = :p_end_time_period_id) and bva.budget_element_id=:budget_element_id order by tim.start_date |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Effective Date |
|
Date | |
Budget |
|
LOV Oracle | |
Version |
|
LOV Oracle | |
Start Period |
|
LOV Oracle | |
End Period |
|
LOV Oracle |