APPS.IGF_AW_LI_IMPORT dependencies on IGS_PE_ALT_PERS_ID

Line 478: FROM igs_pe_alt_pers_id api,

474: l_return_status_db VARCHAR2(1);
475:
476: CURSOR c_get_person_ssn IS
477: SELECT api.api_person_id, api.person_id_type, api.start_dt, api.end_dt
478: FROM igs_pe_alt_pers_id api,
479: igf_ap_fa_base_rec_all fabase,
480: igs_pe_person_id_typ pid
481: WHERE fabase.person_id = api.pe_person_id
482: AND fabase.base_id = g_base_id