APPS.PAY_US_USER_CITY_UPGRADE_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 226: SELECT pay_assignment_actions_s.nextval

222: WHILE (c_get_assignments%FOUND)
223:
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,

Line 288: l_assignment_id pay_assignment_actions.object_id%TYPE;

284: FROM pay_payroll_actions ppa
285: WHERE ppa.payroll_action_id = p_payroll_action_id;
286:
287: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
288: l_assignment_id pay_assignment_actions.object_id%TYPE;
289: l_mode VARCHAR2(8);
290: l_id pay_patch_status.id%TYPE;
291: l_patch_name pay_patch_status.patch_name%TYPE;
292: