DBA Data[Home] [Help]

APPS.PAY_CA_EOY_RL2_AMEND_REG dependencies on PAY_ASSIGNMENT_ACTIONS_S

Line 273: ln_serial_number pay_assignment_actions.serial_number%TYPE;

269: lv_employee_number per_people_f.employee_number%type;
270: lv_message varchar2(100):= null;
271: lv_full_name per_people_f.full_name%type;
272: lv_record_name varchar2(100);
273: ln_serial_number pay_assignment_actions.serial_number%TYPE;
274: lv_ppr_report_type varchar2(50);
275:
276: CURSOR c_selected_asg_set(cp_start_person in number
277: ,cp_end_person in number

Line 521: select pay_assignment_actions_s.nextval

517: /* Create an assignment action for this person */
518: hr_utility.trace('get_latest_rl2_amend_dtls found ');
519: hr_utility.trace('Report Type: '||lv_report_type);
520:
521: select pay_assignment_actions_s.nextval
522: into ln_rl2_amend_reg_asg_action
523: from dual;
524:
525: hr_utility.trace('New RL2 Amend Action = ' ||

Line 626: select pay_assignment_actions_s.nextval

622: hr_utility.trace('Report Type: '||lv_report_type);
623:
624: /* Create an assignment action for this person */
625:
626: select pay_assignment_actions_s.nextval
627: into ln_rl2_amend_reg_asg_action
628: from dual;
629:
630: hr_utility.trace('New RL2 Amend Action = ' || ln_rl2_amend_reg_asg_action);