PER Staffing Budget Details

Description
Categories: BI Publisher
Columns: Period, Start Date, End Date, Budget Value, Budget Element Id1, C Start Value, C End Value, C Amount, C Percentage ...
Application: Human Resources
Source: Staffing Budget Details Report (XML)
Short Name: PERRPRBD_XML
DB package: PER_PERRPRBD_XMLP_PKG
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
Business Group Id
 
Number