APPS.PAY_US_EMPLOYEE_BALANCES dependencies on DUAL

Line 752: FROM dual;

748: -- Set the year end date as the final process date if not specified
749: IF l_last_process_date is NULL THEN
750: SELECT trunc(add_months(l_date,12),'Y')-1
751: INTO l_last_process_date
752: FROM dual;
753: END IF;
754:
755: IF l_date>nvl(l_last_process_date,l_date) THEN
756: l_last_process_date:=l_date;

Line 997: FROM dual;

993: -- Set the year end date as the final process date if not specified
994: IF l_last_process_date is NULL THEN
995: SELECT trunc(add_months(l_date,12),'Y')-1
996: INTO l_last_process_date
997: FROM dual;
998: END IF;
999:
1000: IF l_date>nvl(l_last_process_date,l_date) THEN
1001: l_last_process_date:=l_date;