APPS.PAY_CA_EOY_T4A_CANCEL_PKG dependencies on PER_PEOPLE_F

Line 409: lv_employee_number per_people_f.employee_number%type;

405: ln_prev_yepp_lock_action pay_assignment_actions.assignment_action_id%TYPE;
406:
407:
408: lv_serial_number VARCHAR2(30);
409: lv_employee_number per_people_f.employee_number%type;
410: lv_message varchar2(240):= null;
411: lv_full_name per_people_f.full_name%type;
412: lv_record_name varchar2(100);
413: lv_prev_report_type pay_payroll_actions.report_type%TYPE;

Line 411: lv_full_name per_people_f.full_name%type;

407:
408: lv_serial_number VARCHAR2(30);
409: lv_employee_number per_people_f.employee_number%type;
410: lv_message varchar2(240):= null;
411: lv_full_name per_people_f.full_name%type;
412: lv_record_name varchar2(100);
413: lv_prev_report_type pay_payroll_actions.report_type%TYPE;
414: ln_prev_lock_action pay_assignment_actions.assignment_action_id%TYPE;
415: ln_prev_w2c_action_id pay_assignment_actions.assignment_action_id%TYPE;

Line 772: from per_people_f

768: --Changes for bug 15886428 starts
769:
770: CURSOR get_warning_dtls_for_ee(cp_person_id in number) is
771: select substr(full_name,1,48), employee_number
772: from per_people_f
773: where person_id = cp_person_id
774: order by effective_end_date desc;
775:
776: CURSOR check_arch_action_exists (p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE) is