APPS.AHL_LTP_RESRC_LEVL_PVT dependencies on DUAL

Line 3628: SELECT LAST_DAY(l_temp_start) INTO l_temp_start FROM DUAL;

3624: ELSE
3625: -- //@@@@@ Remove Hardcoding
3626: x_per_rsrc_tbl(l_temp_index).PERIOD_STRING := TO_CHAR(l_temp_start, 'fmMONTH YYYY');
3627: END IF;
3628: SELECT LAST_DAY(l_temp_start) INTO l_temp_start FROM DUAL;
3629: l_temp_start := l_temp_start + 1; -- First day of next month
3630: x_per_rsrc_tbl(l_temp_index).PERIOD_END := l_temp_start;
3631: l_temp_index := l_temp_index + 1;
3632: