APPS.PAY_US_W2C_RPT dependencies on PER_ALL_PEOPLE_F

Line 354: lv_employee_number per_all_people_f.employee_number%type;

350: ln_prev_yepp_lock_action pay_assignment_actions.assignment_action_id%TYPE;
351:
352:
353: lv_serial_number VARCHAR2(30);
354: lv_employee_number per_all_people_f.employee_number%type;
355: lv_message varchar2(50);
356: lv_full_name per_all_people_f.full_name%type;
357: lv_record_name varchar2(50);
358: lv_prev_report_type pay_payroll_actions.report_type%TYPE;

Line 356: lv_full_name per_all_people_f.full_name%type;

352:
353: lv_serial_number VARCHAR2(30);
354: lv_employee_number per_all_people_f.employee_number%type;
355: lv_message varchar2(50);
356: lv_full_name per_all_people_f.full_name%type;
357: lv_record_name varchar2(50);
358: lv_prev_report_type pay_payroll_actions.report_type%TYPE;
359: ln_prev_lock_action pay_assignment_actions.assignment_action_id%TYPE;
360: ln_prev_w2c_action_id pay_assignment_actions.assignment_action_id%TYPE;

Line 488: from per_all_people_f

484:
485:
486: CURSOR get_warning_dtls_for_ee(cp_person_id in number) is
487: select substr(full_name,1,48), employee_number
488: from per_all_people_f
489: where person_id = cp_person_id
490: order by effective_end_date desc;
491:
492: BEGIN