DBA Data[Home] [Help]

APPS.PAY_CA_EOY_T4A_AMEND_REG dependencies on PER_PEOPLE_F

Line 426: lv_employee_number per_people_f.employee_number%type;

422: l_report_format pay_report_format_mappings_f.report_format%type;
423: -- Variables declared for bug 10399514
424:
425: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%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;

Line 428: lv_full_name per_people_f.full_name%type;

424:
425: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%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;

Line 824: from per_people_f

820:
821:
822: CURSOR get_warning_dtls_for_ee(cp_person_id in number) is
823: select substr(full_name,1,48), employee_number
824: from per_people_f
825: where person_id = cp_person_id
826: order by effective_end_date desc;
827:
828: CURSOR c_get_fed_amend_flag(cp_asg_act_id number