APPS.PJI_EV_UTIL dependencies on PJI_TIME_CAL_YEAR_V

Line 59: FROM pji_time_cal_year_v

55: AND calendar_id=p_calendar_id
56: AND 'PJI_TIME_CAL_QTR_V'=p_slice_name
57: UNION ALL
58: SELECT cal_year_id period_id , end_date
59: FROM pji_time_cal_year_v
60: WHERE end_date >= TO_DATE(p_start_date,'j')
61: AND start_date <= TO_DATE(p_end_date,'j')
62: AND calendar_id=p_calendar_id
63: AND 'PJI_TIME_CAL_YEAR_V'=p_slice_name

Line 63: AND 'PJI_TIME_CAL_YEAR_V'=p_slice_name

59: FROM pji_time_cal_year_v
60: WHERE end_date >= TO_DATE(p_start_date,'j')
61: AND start_date <= TO_DATE(p_end_date,'j')
62: AND calendar_id=p_calendar_id
63: AND 'PJI_TIME_CAL_YEAR_V'=p_slice_name
64: ORDER BY period_id;
65:
66: CURSOR object_type IS
67: SELECT object_type