APPS.PAY_CA_EOY_T4_CANCEL_PKG dependencies on PAY_ASSIGNMENT_ACTIONS_S

Line 447: ln_serial_number pay_assignment_actions.serial_number%TYPE;

443: lv_record_name varchar2(100);
444: lv_prev_report_type pay_payroll_actions.report_type%TYPE;
445: ln_prev_lock_action pay_assignment_actions.assignment_action_id%TYPE;
446: ln_prev_w2c_action_id pay_assignment_actions.assignment_action_id%TYPE;
447: ln_serial_number pay_assignment_actions.serial_number%TYPE;
448: ln_gre_id NUMBER;
449: ln_gre_parameter NUMBER;
450: lv_ppr_report_type varchar2(50);
451: -- Variables declared for bug 10399514

Line 831: lv_serial_number pay_assignment_actions.serial_number%TYPE;

827: ln_yepp_pact_id number;
828: ln_gre_id_null number;
829: ln_iteration number :=0;
830: lv_flag_count number :=0;
831: lv_serial_number pay_assignment_actions.serial_number%TYPE;
832: l_arch_action_exists varchar2(2);
833:
834: lv_negative_bal_flag varchar2(10);
835: lv_neg_bal_mesg varchar2(100);

Line 960: select pay_assignment_actions_s.nextval

956: 'PRINT',
957: 'ASSIGNMENT',
958: ln_primary_assignment_id,
959: l_effective_end_date),'Y') = 'Y' then
960: select pay_assignment_actions_s.nextval
961: into ln_t4cancel_asg_action
962: from dual;
963:
964: hr_utility.trace('New T4 Cancel Action = ' ||

Line 1103: select pay_assignment_actions_s.nextval

1099: 'ASSIGNMENT',
1100: ln_primary_assignment_id,
1101: l_effective_end_date),'Y') = 'Y' then
1102:
1103: select pay_assignment_actions_s.nextval
1104: into ln_t4cancel_asg_action
1105: from dual;
1106:
1107: hr_utility.trace('New T4 Cancel Action = ' ||