APPS.IGF_AP_LI_PROF_IMP_PROC dependencies on IGS_PE_ALT_PERS_ID

Line 5885: FROM igs_pe_alt_pers_id api,

5881: -- Get the details of
5882: CURSOR c_get_person_id(lv_ssn VARCHAR2) IS
5883: SELECT 'SSN' rec_type,
5884: api.pe_person_id person_id
5885: FROM igs_pe_alt_pers_id api,
5886: igs_pe_person_id_typ pit
5887: WHERE api.person_id_type = pit.person_id_type
5888: AND pit.s_person_id_type = 'SSN'
5889: AND sysdate between api.start_dt AND NVL(api.end_dt,sysdate)