1365: while l_day <= p_to_date loop
1366:
1367: -- check if the current day is loaded
1368: select count(*) into l_count
1369: from fii_time_day
1370: where report_date = trunc(l_day);
1371:
1372: if l_count = 0 then --this day is not loaded
1373: l_has_missing_date := true;
1455: while l_day <= l_to_date loop
1456:
1457: -- check if the current day is loaded
1458: select count(*) into l_count
1459: from fii_time_day
1460: where report_date = trunc(l_day);
1461:
1462: if l_count = 0 then --this day is not loaded
1463: l_has_missing_date := true;