1849: IF l_rec_count > 12 THEN
1850:
1851: SELECT COUNT(*)
1852: INTO l_rec_count
1853: FROM pji_time_ent_qtr_v
1854: WHERE start_date >= l_start_date
1855: AND end_date <= l_end_date;
1856:
1857: IF l_rec_count <= 1 THEN
1864: WHERE start_date >= l_start_date
1865: AND end_date <= l_end_date;
1866:
1867: IF l_rec_count <=1 THEN
1868: x_slice_name := 'PJI_TIME_ENT_QTR_V';
1869: ELSE
1870: x_slice_name := 'PJI_TIME_ENT_YEAR_V';
1871: END IF;
1872: ELSE
1869: ELSE
1870: x_slice_name := 'PJI_TIME_ENT_YEAR_V';
1871: END IF;
1872: ELSE
1873: x_slice_name := 'PJI_TIME_ENT_QTR_V';
1874: END IF;
1875: ELSE
1876: x_slice_name := 'PJI_TIME_ENT_PERIOD_V';
1877: END IF;