APPS.PJI_EV_UTIL dependencies on PJI_TIME_ENT_YEAR_V

Line 37: FROM pji_time_ent_year_v

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')
39: AND start_date <= TO_DATE(p_end_date,'j')
40: AND 'PJI_TIME_ENT_YEAR_V'=p_slice_name
41: ORDER BY period_id;

Line 40: AND 'PJI_TIME_ENT_YEAR_V'=p_slice_name

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')
39: AND start_date <= TO_DATE(p_end_date,'j')
40: AND 'PJI_TIME_ENT_YEAR_V'=p_slice_name
41: ORDER BY period_id;
42:
43: CURSOR gl_pa_periods IS
44: SELECT cal_period_id period_id , end_date