DBA Data[Home] [Help]

APPS.PAY_CA_EOY_T4A_AMEND_REG dependencies on PAY_ASSIGNMENT_ACTIONS_S

Line 286: ln_serial_number pay_assignment_actions.serial_number%TYPE;

282: lv_employee_number per_people_f.employee_number%type;
283: lv_message varchar2(100):= null;
284: lv_full_name per_people_f.full_name%type;
285: lv_record_name varchar2(100);
286: ln_serial_number pay_assignment_actions.serial_number%TYPE;
287: ln_gre_id NUMBER;
288: ln_gre_parameter NUMBER;
289: lv_ppr_report_type varchar2(50);
290:

Line 535: select pay_assignment_actions_s.nextval

531: /* Create an assignment action for this person */
532: hr_utility.trace('get_latest_t4a_amend_dtls found ');
533: hr_utility.trace('Report Type: '||lv_report_type);
534:
535: select pay_assignment_actions_s.nextval
536: into ln_t4a_amend_reg_asg_action
537: from dual;
538:
539: hr_utility.trace('New T4A Amend Action = ' ||

Line 642: select pay_assignment_actions_s.nextval

638: hr_utility.trace('Report Type: '||lv_report_type);
639:
640: /* Create an assignment action for this person */
641:
642: select pay_assignment_actions_s.nextval
643: into ln_t4a_amend_reg_asg_action
644: from dual;
645:
646: hr_utility.trace('New T4A Amend Action = ' || ln_t4a_amend_reg_asg_action);