APPS.PAY_CA_EOY_T4A_AMEND_REG dependencies on PAY_ASSIGNMENT_ACTIONS_S

Line 430: ln_serial_number pay_assignment_actions.serial_number%TYPE;

426: lv_employee_number per_people_f.employee_number%type;
427: lv_message varchar2(300):= null; --#5046003 Increased size from 100 to 300
428: lv_full_name per_people_f.full_name%type;
429: lv_record_name varchar2(100);
430: ln_serial_number pay_assignment_actions.serial_number%TYPE;
431: ln_gre_id NUMBER;
432: ln_gre_parameter NUMBER;
433: lv_ppr_report_type varchar2(50);
434:

Line 946: select pay_assignment_actions_s.nextval

942: 'ASSIGNMENT',
943: ln_primary_assignment_id,
944: l_effective_end_date),'Y') = 'Y' then
945:
946: select pay_assignment_actions_s.nextval
947: into ln_t4a_amend_reg_asg_action
948: from dual;
949:
950: hr_utility.trace('New T4A Amend Action = ' ||

Line 1102: select pay_assignment_actions_s.nextval

1098: 'PRINT',
1099: 'ASSIGNMENT',
1100: ln_primary_assignment_id,
1101: l_effective_end_date),'Y') = 'Y' then
1102: select pay_assignment_actions_s.nextval
1103: into ln_t4a_amend_reg_asg_action
1104: from dual;
1105:
1106: hr_utility.trace('New T4A Amend Action = ' ||

Line 1240: select pay_assignment_actions_s.nextval

1236: /* Create an assignment action for this person */
1237: hr_utility.trace('get_latest_t4a_amend_dtls found ');
1238: hr_utility.trace('Report Type: '||lv_report_type);
1239:
1240: select pay_assignment_actions_s.nextval
1241: into ln_t4a_amend_reg_asg_action
1242: from dual;
1243:
1244: hr_utility.trace('New T4A Amend Action = ' ||

Line 1347: select pay_assignment_actions_s.nextval

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