APPS.PAY_CA_EOY_T4_AMEND_REG dependencies on PAY_ASSIGNMENT_ACTIONS_S

Line 322: ln_serial_number pay_assignment_actions.serial_number%TYPE;

318: lv_record_name varchar2(100);
319: lv_prev_report_type pay_payroll_actions.report_type%TYPE;
320: ln_prev_lock_action pay_assignment_actions.assignment_action_id%TYPE;
321: ln_prev_w2c_action_id pay_assignment_actions.assignment_action_id%TYPE;
322: ln_serial_number pay_assignment_actions.serial_number%TYPE;
323: ln_gre_id NUMBER;
324: ln_gre_parameter NUMBER;
325: lv_ppr_report_type varchar2(50);
326:

Line 581: select pay_assignment_actions_s.nextval

577: /* Create an assignment action for this person */
578: hr_utility.trace('get_latest_t4amend_dtls found ');
579: hr_utility.trace('Report Type: '||lv_report_type);
580:
581: select pay_assignment_actions_s.nextval
582: into ln_t4amend_reg_asg_action
583: from dual;
584:
585: hr_utility.trace('New T4 Amend Action = ' ||

Line 690: select pay_assignment_actions_s.nextval

686: hr_utility.trace('Report Type: '||lv_report_type);
687:
688: /* Create an assignment action for this person */
689:
690: select pay_assignment_actions_s.nextval
691: into ln_t4amend_reg_asg_action
692: from dual;
693: hr_utility.trace('New T4 Amend Action = ' || ln_t4amend_reg_asg_action);
694: