APPS.PAY_US_W2C_ARCH dependencies on PER_ALL_PEOPLE_F

Line 314: lv_national_identifier per_all_people_f.national_identifier%type;

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

Line 316: lv_full_name per_all_people_f.full_name%type;

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

Line 375: from per_all_people_f

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