APPS.PAY_CA_EOY_T4_AMEND_REG dependencies on PER_PEOPLE_F

Line 454: lv_employee_number per_people_f.employee_number%type;

450: ln_prev_yepp_lock_action pay_assignment_actions.assignment_action_id%TYPE;
451:
452:
453: lv_serial_number VARCHAR2(30);
454: lv_employee_number per_people_f.employee_number%type;
455: lv_message varchar2(240):= null; /*Increased size of variable for Bug#4676544*/
456: lv_full_name per_people_f.full_name%type;
457: lv_record_name varchar2(100);
458: lv_prev_report_type pay_payroll_actions.report_type%TYPE;

Line 456: lv_full_name per_people_f.full_name%type;

452:
453: lv_serial_number VARCHAR2(30);
454: lv_employee_number per_people_f.employee_number%type;
455: lv_message varchar2(240):= null; /*Increased size of variable for Bug#4676544*/
456: lv_full_name per_people_f.full_name%type;
457: lv_record_name varchar2(100);
458: lv_prev_report_type pay_payroll_actions.report_type%TYPE;
459: ln_prev_lock_action pay_assignment_actions.assignment_action_id%TYPE;
460: ln_prev_w2c_action_id pay_assignment_actions.assignment_action_id%TYPE;

Line 867: from per_people_f

863:
864:
865: CURSOR get_warning_dtls_for_ee(cp_person_id in number) is
866: select substr(full_name,1,48), employee_number
867: from per_people_f
868: where person_id = cp_person_id
869: order by effective_end_date desc;
870:
871: CURSOR c_get_fed_amend_flag(cp_asg_act_id number