DBA Data[Home] [Help]

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;