APPS.IGF_AP_PROFILE_MATCHING_PKG dependencies on IGS_PE_PERSON_ID_TYP

Line 4058: FROM igs_pe_alt_pers_id apii, igs_pe_person_id_typ pit

4054: hz.email_address email_address,
4055: hp.date_of_birth date_of_birth,
4056: hp.gender gender
4057: FROM ( SELECT apii.pe_person_id, apii.api_person_id_uf
4058: FROM igs_pe_alt_pers_id apii, igs_pe_person_id_typ pit
4059: WHERE apii.person_id_type = pit.person_id_type
4060: AND pit.s_person_id_type = 'SSN'
4061: AND SYSDATE BETWEEN apii.start_dt AND NVL (apii.end_dt, SYSDATE)) api,
4062: hz_parties hz,