APPS.IGF_AP_PROFILE_GEN_PKG dependencies on IGS_PE_ALT_PERS_ID

Line 77: FROM igs_pe_alt_pers_id

73: ) IS
74: SELECT api_person_id,
75: api_person_id_uf,
76: end_dt
77: FROM igs_pe_alt_pers_id
78: WHERE pe_person_id = cp_person_id
79: AND person_id_type LIKE 'SSN'
80: AND SYSDATE BETWEEN start_dt AND NVL(end_dt,SYSDATE);
81: l_ssn c_ssn%ROWTYPE;