APPS.PAY_CA_EOY_T4_CANCEL_PKG dependencies on PER_PEOPLE_F

Line 440: lv_employee_number per_people_f.employee_number%type;

436: ln_prev_yepp_lock_action pay_assignment_actions.assignment_action_id%TYPE;
437:
438:
439: lv_serial_number VARCHAR2(30);
440: lv_employee_number per_people_f.employee_number%type;
441: lv_message varchar2(240):= null;
442: lv_full_name per_people_f.full_name%type;
443: lv_record_name varchar2(100);
444: lv_prev_report_type pay_payroll_actions.report_type%TYPE;

Line 442: lv_full_name per_people_f.full_name%type;

438:
439: lv_serial_number VARCHAR2(30);
440: lv_employee_number per_people_f.employee_number%type;
441: lv_message varchar2(240):= null;
442: lv_full_name per_people_f.full_name%type;
443: lv_record_name varchar2(100);
444: lv_prev_report_type pay_payroll_actions.report_type%TYPE;
445: ln_prev_lock_action pay_assignment_actions.assignment_action_id%TYPE;
446: ln_prev_w2c_action_id pay_assignment_actions.assignment_action_id%TYPE;

Line 817: from per_people_f

813: where assignment_action_id = p_assignment_action_id;
814:
815: CURSOR get_warning_dtls_for_ee(cp_person_id in number) is
816: select substr(full_name,1,48), employee_number
817: from per_people_f
818: where person_id = cp_person_id
819: order by effective_end_date desc;
820:
821: