APPS.PJI_EV_UTIL dependencies on PJI_TIME_CAL_QTR_V

Line 52: FROM pji_time_cal_qtr_v

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')
54: AND start_date <= TO_DATE(p_end_date,'j')
55: AND calendar_id=p_calendar_id
56: AND 'PJI_TIME_CAL_QTR_V'=p_slice_name

Line 56: AND 'PJI_TIME_CAL_QTR_V'=p_slice_name

52: FROM pji_time_cal_qtr_v
53: WHERE end_date >= TO_DATE(p_start_date,'j')
54: AND start_date <= TO_DATE(p_end_date,'j')
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')