1355: IF G_RETAIN_DATE = 'Y' THEN
1356: BEGIN
1357: SELECT FIRST_WORKING_DATE, LAST_WORKING_DATE
1358: INTO l_first_work_day, l_last_work_day
1359: FROM MSC_CALENDARS
1360: WHERE SR_INSTANCE_ID = p_instance_id
1361: AND CALENDAR_CODE = p_calendar_code;
1362: EXCEPTION
1363: WHEN NO_DATA_FOUND THEN
1413: IF G_RETAIN_DATE = 'Y' THEN
1414: BEGIN
1415: SELECT FIRST_WORKING_DATE, LAST_WORKING_DATE
1416: INTO l_first_work_day, l_last_work_day
1417: FROM MSC_CALENDARS
1418: WHERE SR_INSTANCE_ID = p_instance_id
1419: AND CALENDAR_CODE = p_calendar_code;
1420: EXCEPTION
1421: WHEN NO_DATA_FOUND THEN
1509: IF G_RETAIN_DATE = 'Y' THEN
1510: BEGIN
1511: SELECT FIRST_WORKING_DATE, LAST_WORKING_DATE
1512: INTO l_first_work_day, l_last_work_day
1513: FROM MSC_CALENDARS
1514: WHERE SR_INSTANCE_ID = p_instance_id
1515: AND CALENDAR_CODE = p_calendar_code;
1516: EXCEPTION
1517: WHEN NO_DATA_FOUND THEN
1561: IF G_RETAIN_DATE = 'Y' THEN
1562: BEGIN
1563: SELECT FIRST_WORKING_DATE, LAST_WORKING_DATE
1564: INTO l_first_work_day, l_last_work_day
1565: FROM MSC_CALENDARS
1566: WHERE SR_INSTANCE_ID = p_instance_id
1567: AND CALENDAR_CODE = p_calendar_code;
1568: EXCEPTION
1569: WHEN NO_DATA_FOUND THEN