DBA Data[Home] [Help]

APPS.PJI_REP_UTIL dependencies on PJI_TIME_CAL_QTR_V

Line 2281: FROM pji_time_cal_qtr_v

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:

Line 2298: x_slice_name := 'PJI_TIME_CAL_QTR_V';

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

Line 2303: 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;
2305: ELSE
2306: x_slice_name := 'PJI_TIME_CAL_PERIOD_V';
2307: END IF;