APPS.PJI_EV_UTIL dependencies on PJI_TIME_ENT_QTR_V

Line 31: FROM pji_time_ent_qtr_v

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')
33: AND start_date <= TO_DATE(p_end_date,'j')
34: AND 'PJI_TIME_ENT_QTR_V'=p_slice_name
35: UNION ALL

Line 34: AND 'PJI_TIME_ENT_QTR_V'=p_slice_name

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')
33: AND start_date <= TO_DATE(p_end_date,'j')
34: AND 'PJI_TIME_ENT_QTR_V'=p_slice_name
35: UNION ALL
36: SELECT ent_year_id period_id , end_date
37: FROM pji_time_ent_year_v
38: WHERE end_date >= TO_DATE(p_start_date,'j')