APPS.PAY_US_W2C_REPORTING_UTILS dependencies on PAY_ASSIGNMENT_ACTIONS_S

Line 854: ln_serial_number pay_assignment_actions.serial_number%TYPE;

850: ln_last_w2cp_pactid NUMBER;
851: ln_last_w2cp_asg_actid NUMBER;
852: ln_last_w2cpp_asg_action_id NUMBER;
853:
854: ln_serial_number pay_assignment_actions.serial_number%TYPE;
855: ln_notlocked_asgn_actid number;
856:
857: BEGIN
858: hr_utility.set_location(gv_package || '.action_creation', 10);

Line 933: select pay_assignment_actions_s.nextval

929: hr_utility.trace('Originally Reported Assignment_Action_ID '||
930: to_char(ln_orig_reported_asg_action));
931:
932: /* Create an assignment action for this person */
933: select pay_assignment_actions_s.nextval
934: into ln_w2c_asg_action
935: from dual;
936: hr_utility.set_location(gv_package || '.action_creation', 120);
937: hr_utility.trace('New w2c Action = ' || to_char(ln_w2c_asg_action));