DBA Data[Home] [Help]

APPS.PAY_US_USER_CITY_UPGRADE_PKG dependencies on PAY_PATCH_STATUS_S

Line 57: SELECT pay_patch_status_s.NEXTVAL

53: INTO l_mode
54: FROM pay_payroll_actions ppa
55: WHERE ppa.payroll_action_id = pactid;
56:
57: SELECT pay_patch_status_s.NEXTVAL
58: INTO l_id FROM dual;
59:
60: l_applied_date := trunc(sysdate);
61: