APPS.PAY_CA_EOY_T4A_AMEND_REG dependencies on PER_PEOPLE_F

Line 282: lv_employee_number per_people_f.employee_number%type;

278:
279: lv_report_type pay_payroll_actions.report_type%TYPE ;
280: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
281:
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;

Line 284: lv_full_name per_people_f.full_name%type;

280: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
281:
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;

Line 427: from per_people_f

423:
424:
425: CURSOR get_warning_dtls_for_ee(cp_person_id in number) is
426: select substr(full_name,1,48), employee_number
427: from per_people_f
428: where person_id = cp_person_id
429: order by effective_end_date desc;
430:
431: CURSOR c_get_fed_amend_flag(cp_asg_act_id number