PER Staffing Budget Details

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