APPS.PJI_REP_UTIL dependencies on PJI_TIME_ENT_YEAR_V
Line 2253: FROM pji_time_ent_year_v
2249: ELSIF l_rec_count > 12 THEN
2250:
2251: SELECT COUNT(*)
2252: INTO l_rec_count 2253: FROM pji_time_ent_year_v 2254: WHERE start_date >= l_start_date
2255: AND end_date <= l_end_date;
2256:
2257: IF l_rec_count <=1 THEN
Line 2260: x_slice_name := 'PJI_TIME_ENT_YEAR_V';
2256:
2257: IF l_rec_count <=1 THEN
2258: x_slice_name := 'PJI_TIME_ENT_QTR_V';
2259: ELSE 2260: x_slice_name := 'PJI_TIME_ENT_YEAR_V'; 2261: END IF;
2262: ELSE
2263: x_slice_name := 'PJI_TIME_ENT_QTR_V';
2264: END IF;