APPS.PAY_US_W2C_ARCH dependencies on PER_ALL_PEOPLE_F

Line 317: lv_national_identifier per_all_people_f.national_identifier%type;

313:
314:
315: lv_serial_number VARCHAR2(30);
316: ln_eoy_pactid number:= 0;
317: lv_national_identifier per_all_people_f.national_identifier%type;
318: lv_message varchar2(150):= null;
319: lv_full_name per_all_people_f.full_name%type;
320: lv_name varchar2(50);
321: lv_record_name varchar2(50);

Line 319: lv_full_name per_all_people_f.full_name%type;

315: lv_serial_number VARCHAR2(30);
316: ln_eoy_pactid number:= 0;
317: lv_national_identifier per_all_people_f.national_identifier%type;
318: lv_message varchar2(150):= null;
319: lv_full_name per_all_people_f.full_name%type;
320: lv_name varchar2(50);
321: lv_record_name varchar2(50);
322: --bug 6909112 starts here
323: l_tmp_asg_id per_all_assignments_f.assignment_id%TYPE;

Line 378: from per_all_people_f

374:
375:
376: CURSOR get_warning_dtls_for_ee(cp_person_id in number) is
377: select substr(full_name,1,31), substr(national_identifier,1,11)
378: from per_all_people_f
379: where person_id = cp_person_id
380: ORDER BY effective_end_date desc;
381:
382: