APPS.PAY_US_W2C_REPORTING_UTILS dependencies on PAY_ASSIGNMENT_ACTIONS_S

Line 843: ln_serial_number pay_assignment_actions.serial_number%TYPE;

839: ln_last_w2cp_pactid NUMBER;
840: ln_last_w2cp_asg_actid NUMBER;
841: ln_last_w2cpp_asg_action_id NUMBER;
842:
843: ln_serial_number pay_assignment_actions.serial_number%TYPE;
844: ln_notlocked_asgn_actid number;
845:
846: BEGIN
847: hr_utility.set_location(gv_package || '.action_creation', 10);

Line 922: select pay_assignment_actions_s.nextval

918: hr_utility.trace('Originally Reported Assignment_Action_ID '||
919: to_char(ln_orig_reported_asg_action));
920:
921: /* Create an assignment action for this person */
922: select pay_assignment_actions_s.nextval
923: into ln_w2c_asg_action
924: from dual;
925: hr_utility.set_location(gv_package || '.action_creation', 120);
926: hr_utility.trace('New w2c Action = ' || to_char(ln_w2c_asg_action));