APPS.IGF_AW_LI_IMPORT dependencies on IGS_PE_PERSON_ID_TYP

Line 480: igs_pe_person_id_typ pid

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
483: AND api.person_id_Type = pid.person_id_type
484: AND pid.s_person_id_type = 'SSN'