DBA Data[Home] [Help]

APPS.PJI_EV_UTIL dependencies on PJI_TIME_ENT_PERIOD_V

Line 25: FROM pji_time_ent_period_v

21: l_calendar_type pji_fp_xbs_accum_f.calendar_type%TYPE := p_calendar_type;
22:
23: CURSOR ent_periods IS
24: SELECT ent_period_id period_id , end_date
25: FROM pji_time_ent_period_v
26: WHERE end_date >= TO_DATE(p_start_date,'j')
27: AND start_date <= TO_DATE(p_end_date,'j')
28: AND 'PJI_TIME_ENT_PERIOD_V'=p_slice_name
29: UNION ALL

Line 28: AND 'PJI_TIME_ENT_PERIOD_V'=p_slice_name

24: SELECT ent_period_id period_id , end_date
25: FROM pji_time_ent_period_v
26: WHERE end_date >= TO_DATE(p_start_date,'j')
27: AND start_date <= TO_DATE(p_end_date,'j')
28: AND 'PJI_TIME_ENT_PERIOD_V'=p_slice_name
29: UNION ALL
30: SELECT ent_qtr_id period_id , end_date
31: FROM pji_time_ent_qtr_v
32: WHERE end_date >= TO_DATE(p_start_date,'j')