APPS.PAY_US_W2C_REPORTING_UTILS dependencies on PER_ALL_PEOPLE_F

Line 791: from per_all_people_f

787: --
788: CURSOR get_warning_dtls_for_ee(cp_person_id in number)
789: is
790: select substr(full_name,1,48), employee_number
791: from per_all_people_f
792: where person_id = cp_person_id
793: order by effective_end_date desc;
794:
795: ld_start_date DATE;

Line 809: lv_national_identifier per_all_people_f.national_identifier%type;

805: ln_assignment_action_id number;
806: ln_w2c_pp_asg_actid number;
807: ln_w2c_pp_locked_actid number;
808:
809: lv_national_identifier per_all_people_f.national_identifier%type;
810: lv_message varchar2(50):= null;
811: lv_full_name per_all_people_f.full_name%type;
812: lv_name varchar2(50);
813: lv_record_name varchar2(50);

Line 811: lv_full_name per_all_people_f.full_name%type;

807: ln_w2c_pp_locked_actid number;
808:
809: lv_national_identifier per_all_people_f.national_identifier%type;
810: lv_message varchar2(50):= null;
811: lv_full_name per_all_people_f.full_name%type;
812: lv_name varchar2(50);
813: lv_record_name varchar2(50);
814: ln_prev_person_id number;
815: