APPS.PAY_US_USER_CITY_UPGRADE_PKG dependencies on DUAL

Line 58: INTO l_id FROM dual;

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:
62: l_patch_name := 'USER_CITY_UPGRADE_'||TO_CHAR(sysdate,'DDMONYYYY');

Line 228: FROM DUAL;

224: LOOP
225:
226: SELECT pay_assignment_actions_s.nextval
227: INTO l_assignment_action_id
228: FROM DUAL;
229:
230: hr_nonrun_asact.insact(lockingactid => l_assignment_action_id,
231: object_Id => l_assignment_id,
232: pactid => pactid,