APPS.PAY_CA_EOY_T4_AMEND_REG dependencies on PER_PEOPLE_F

Line 315: lv_employee_number per_people_f.employee_number%type;

311: ln_prev_yepp_lock_action pay_assignment_actions.assignment_action_id%TYPE;
312:
313:
314: lv_serial_number VARCHAR2(30);
315: lv_employee_number per_people_f.employee_number%type;
316: lv_message varchar2(100):= null;
317: lv_full_name per_people_f.full_name%type;
318: lv_record_name varchar2(100);
319: lv_prev_report_type pay_payroll_actions.report_type%TYPE;

Line 317: lv_full_name per_people_f.full_name%type;

313:
314: lv_serial_number VARCHAR2(30);
315: lv_employee_number per_people_f.employee_number%type;
316: lv_message varchar2(100):= null;
317: lv_full_name per_people_f.full_name%type;
318: lv_record_name varchar2(100);
319: lv_prev_report_type pay_payroll_actions.report_type%TYPE;
320: ln_prev_lock_action pay_assignment_actions.assignment_action_id%TYPE;
321: ln_prev_w2c_action_id pay_assignment_actions.assignment_action_id%TYPE;

Line 465: from per_people_f

461:
462:
463: CURSOR get_warning_dtls_for_ee(cp_person_id in number) is
464: select substr(full_name,1,48), employee_number
465: from per_people_f
466: where person_id = cp_person_id
467: order by effective_end_date desc;
468:
469: CURSOR c_get_fed_amend_flag(cp_asg_act_id number