APPS.PAY_CA_EOY_T4A_AMEND_ARCH dependencies on PER_ALL_PEOPLE_F

Line 371: lv_national_identifier per_all_people_f.national_identifier%type;

367: ln_asg_act_to_lock pay_assignment_actions.assignment_action_id%TYPE;
368:
369:
370: lv_serial_number VARCHAR2(30);
371: lv_national_identifier per_all_people_f.national_identifier%type;
372: lv_message varchar2(100):= null;
373: lv_full_name per_all_people_f.full_name%type;
374: lv_name varchar2(100);
375: lv_record_name varchar2(80);

Line 373: lv_full_name per_all_people_f.full_name%type;

369:
370: lv_serial_number VARCHAR2(30);
371: lv_national_identifier per_all_people_f.national_identifier%type;
372: lv_message varchar2(100):= null;
373: lv_full_name per_all_people_f.full_name%type;
374: lv_name varchar2(100);
375: lv_record_name varchar2(80);
376:
377:

Line 454: from per_all_people_f

450: order by paa.assignment_action_id desc;
451:
452: CURSOR get_warning_dtls_for_ee(cp_person_id in number) is
453: select substr(full_name,1,31), substr(national_identifier,1,11)
454: from per_all_people_f
455: where person_id = cp_person_id
456: ORDER BY effective_end_date desc;
457:
458: BEGIN