APPS.PAY_CA_EOY_RL2_CANCEL_PKG dependencies on PAY_ASSIGNMENT_ACTIONS_S

Line 403: ln_serial_number pay_assignment_actions.serial_number%TYPE;

399: lv_record_name varchar2(100);
400: lv_prev_report_type pay_payroll_actions.report_type%TYPE;
401: ln_prev_lock_action pay_assignment_actions.assignment_action_id%TYPE;
402: ln_prev_w2c_action_id pay_assignment_actions.assignment_action_id%TYPE;
403: ln_serial_number pay_assignment_actions.serial_number%TYPE;
404: ln_pre_id NUMBER;
405: ln_pre_parameter NUMBER;
406: lv_ppr_report_type varchar2(50);
407:

Line 785: lv_serial_number pay_assignment_actions.serial_number%TYPE;

781: ln_yepp_pact_id number;
782: ln_pre_id_null number;
783: ln_iteration number :=0;
784: lv_flag_count number :=0;
785: lv_serial_number pay_assignment_actions.serial_number%TYPE;
786:
787:
788: lv_negative_bal_flag varchar2(10);
789: lv_neg_bal_mesg varchar2(100);

Line 935: select pay_assignment_actions_s.nextval

931: /* Create an assignment action for this person */
932: hr_utility.trace('get_latest_rl2_cancel_dtls found ');
933: hr_utility.trace('Report Type: '||lv_report_type);
934:
935: select pay_assignment_actions_s.nextval
936: into ln_rl2_cancel_asg_action
937: from dual;
938:
939: hr_utility.trace('New rl2 Amend Action = ' ||

Line 1084: select pay_assignment_actions_s.nextval

1080: /* Create an assignment action for this person */
1081: hr_utility.trace('get_reprint_rl2amendpdf_dtls found ');
1082: hr_utility.trace('Report Type: '||lv_report_type);
1083:
1084: select pay_assignment_actions_s.nextval
1085: into ln_rl2_cancel_asg_action
1086: from dual;
1087:
1088: hr_utility.trace('New rl2 Cancel Action = ' ||