2277: IF l_rec_count > 12 THEN
2278:
2279: SELECT COUNT(*)
2280: INTO l_rec_count
2281: FROM pji_time_cal_qtr_v
2282: WHERE start_date >= l_start_date
2283: AND end_date <= l_end_date
2284: AND calendar_id = p_calendar_id;
2285:
2294: AND end_date <= l_end_date
2295: AND calendar_id = p_calendar_id;
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
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;
2305: ELSE
2306: x_slice_name := 'PJI_TIME_CAL_PERIOD_V';
2307: END IF;