1887: IF l_rec_count > 12 THEN
1888:
1889: SELECT COUNT(*)
1890: INTO l_rec_count
1891: FROM pji_time_cal_qtr_v
1892: WHERE start_date >= l_start_date
1893: AND end_date <= l_end_date
1894: AND calendar_id = p_calendar_id;
1895:
1904: AND end_date <= l_end_date
1905: AND calendar_id = p_calendar_id;
1906:
1907: IF l_rec_count <=1 THEN
1908: x_slice_name := 'PJI_TIME_CAL_QTR_V';
1909: ELSE
1910: x_slice_name := 'PJI_TIME_CAL_YEAR_V';
1911: END IF;
1912: ELSE
1909: ELSE
1910: x_slice_name := 'PJI_TIME_CAL_YEAR_V';
1911: END IF;
1912: ELSE
1913: x_slice_name := 'PJI_TIME_CAL_QTR_V';
1914: END IF;
1915: ELSE
1916: x_slice_name := 'PJI_TIME_CAL_PERIOD_V';
1917: END IF;