APPS.PAY_CA_EOY_RL1_AMEND_REG dependencies on PAY_ASSIGNMENT_ACTIONS_S

Line 289: ln_serial_number pay_assignment_actions.serial_number%TYPE;

285: lv_employee_number per_people_f.employee_number%type;
286: lv_message varchar2(100):= null;
287: lv_full_name per_people_f.full_name%type;
288: lv_record_name varchar2(100);
289: ln_serial_number pay_assignment_actions.serial_number%TYPE;
290: lv_ppr_report_type varchar2(50);
291:
292: CURSOR c_selected_asg_set(cp_start_person in number
293: ,cp_end_person in number

Line 562: select pay_assignment_actions_s.nextval

558: /* Create an assignment action for this person */
559: hr_utility.trace('get_latest_rl1_amend_dtls found ');
560: hr_utility.trace('Report Type: '||lv_report_type);
561:
562: select pay_assignment_actions_s.nextval
563: into ln_rl1_amend_reg_asg_action
564: from dual;
565:
566: hr_utility.trace('New RL1 Amend Action = ' ||

Line 672: select pay_assignment_actions_s.nextval

668: hr_utility.trace('Report Type: '||lv_report_type);
669:
670: /* Create an assignment action for this person */
671:
672: select pay_assignment_actions_s.nextval
673: into ln_rl1_amend_reg_asg_action
674: from dual;
675: hr_utility.trace('New RL1 Amend Action = ' || ln_rl1_amend_reg_asg_action);
676: