DBA Data[Home] [Help]

APPS.PJI_REP_UTIL dependencies on PJI_TIME_CAL_YEAR_V

Line 2292: FROM pji_time_cal_year_v

2288: ELSIF l_rec_count > 12 THEN
2289:
2290: SELECT COUNT(*)
2291: INTO l_rec_count
2292: FROM pji_time_cal_year_v
2293: WHERE start_date >= l_start_date
2294: AND end_date <= l_end_date
2295: AND calendar_id = p_calendar_id;
2296:

Line 2300: x_slice_name := 'PJI_TIME_CAL_YEAR_V';

2296:
2297: IF l_rec_count <=1 THEN
2298: x_slice_name := 'PJI_TIME_CAL_QTR_V';
2299: ELSE
2300: x_slice_name := 'PJI_TIME_CAL_YEAR_V';
2301: END IF;
2302: ELSE
2303: x_slice_name := 'PJI_TIME_CAL_QTR_V';
2304: END IF;