APPS.PAY_CA_RL2_AMEND_MAG dependencies on PAY_ASSIGNMENT_ACTIONS_S

Line 551: ln_serial_number pay_assignment_actions.serial_number%TYPE;

547: lv_full_name per_people_f.full_name%type;
548: lv_record_name varchar2(100);
549: lv_prov_of_emp varchar2(10);
550: lv_prov_amend_flag varchar2(5);
551: ln_serial_number pay_assignment_actions.serial_number%TYPE;
552: l_paa_update_check pay_assignment_actions.assignment_action_id%TYPE;
553:
554: BEGIN
555:

Line 648: select pay_assignment_actions_s.nextval

644: hr_utility.set_location('pay_ca_rl2_amend_mag.create_assignment_act', 40);
645:
646: /* Create an assignment action for this person */
647:
648: select pay_assignment_actions_s.nextval
649: into lockingactid
650: from dual;
651: hr_utility.set_location('pay_ca_rl2_amend_mag.create_assignement_act', 50);
652: hr_utility.trace('New RL2 Amend Action = ' ||