DBA Data[Home] [Help]

APPS.PJI_REP_UTIL dependencies on PJI_TIME_ENT_QTR_V

Line 2243: FROM pji_time_ent_qtr_v

2239: IF l_rec_count > 12 THEN
2240:
2241: SELECT COUNT(*)
2242: INTO l_rec_count
2243: FROM pji_time_ent_qtr_v
2244: WHERE start_date >= l_start_date
2245: AND end_date <= l_end_date;
2246:
2247: IF l_rec_count <= 1 THEN

Line 2258: x_slice_name := 'PJI_TIME_ENT_QTR_V';

2254: WHERE start_date >= l_start_date
2255: AND end_date <= l_end_date;
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

Line 2263: 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;
2265: ELSE
2266: x_slice_name := 'PJI_TIME_ENT_PERIOD_V';
2267: END IF;