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
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
Blitz Report™