APPS.PAY_CA_EOY_T4_AMEND_REG dependencies on PAY_ASSIGNMENT_ACTIONS_S

Line 461: ln_serial_number pay_assignment_actions.serial_number%TYPE;

457: lv_record_name varchar2(100);
458: lv_prev_report_type pay_payroll_actions.report_type%TYPE;
459: ln_prev_lock_action pay_assignment_actions.assignment_action_id%TYPE;
460: ln_prev_w2c_action_id pay_assignment_actions.assignment_action_id%TYPE;
461: ln_serial_number pay_assignment_actions.serial_number%TYPE;
462: ln_gre_id NUMBER;
463: ln_gre_parameter NUMBER;
464: lv_ppr_report_type varchar2(50);
465:

Line 1024: select pay_assignment_actions_s.nextval

1020: 'PRINT',
1021: 'ASSIGNMENT',
1022: ln_primary_assignment_id,
1023: l_effective_end_date),'Y') = 'Y' then
1024: select pay_assignment_actions_s.nextval
1025: into ln_t4amend_reg_asg_action
1026: from dual;
1027:
1028: hr_utility.trace('New T4 Amend Action = ' ||

Line 1212: select pay_assignment_actions_s.nextval

1208: 'PRINT',
1209: 'ASSIGNMENT',
1210: ln_primary_assignment_id,
1211: l_effective_end_date),'Y') = 'Y' then
1212: select pay_assignment_actions_s.nextval
1213: into ln_t4amend_reg_asg_action
1214: from dual;
1215:
1216: hr_utility.trace('New T4 Amend Action = ' ||

Line 1346: select pay_assignment_actions_s.nextval

1342: /* Create an assignment action for this person */
1343: hr_utility.trace('get_latest_t4amend_dtls found ');
1344: hr_utility.trace('Report Type: '||lv_report_type);
1345:
1346: select pay_assignment_actions_s.nextval
1347: into ln_t4amend_reg_asg_action
1348: from dual;
1349:
1350: hr_utility.trace('New T4 Amend Action = ' ||

Line 1455: select pay_assignment_actions_s.nextval

1451: hr_utility.trace('Report Type: '||lv_report_type);
1452:
1453: /* Create an assignment action for this person */
1454:
1455: select pay_assignment_actions_s.nextval
1456: into ln_t4amend_reg_asg_action
1457: from dual;
1458: hr_utility.trace('New T4 Amend Action = ' || ln_t4amend_reg_asg_action);
1459: