APPS.PJI_EV_UTIL dependencies on PJI_TIME_CAL_PERIOD_V

Line 45: FROM pji_time_cal_period_v

41: ORDER BY period_id;
42:
43: CURSOR gl_pa_periods IS
44: SELECT cal_period_id period_id , end_date
45: FROM pji_time_cal_period_v
46: WHERE end_date >= TO_DATE(p_start_date,'j')
47: AND start_date <= TO_DATE(p_end_date,'j')
48: AND calendar_id=p_calendar_id
49: AND 'PJI_TIME_CAL_PERIOD_V'=p_slice_name

Line 49: AND 'PJI_TIME_CAL_PERIOD_V'=p_slice_name

45: FROM pji_time_cal_period_v
46: WHERE end_date >= TO_DATE(p_start_date,'j')
47: AND start_date <= TO_DATE(p_end_date,'j')
48: AND calendar_id=p_calendar_id
49: AND 'PJI_TIME_CAL_PERIOD_V'=p_slice_name
50: UNION ALL
51: SELECT cal_qtr_id period_id , end_date
52: FROM pji_time_cal_qtr_v
53: WHERE end_date >= TO_DATE(p_start_date,'j')