APPS.IGF_AP_LI_PROF_IMP_PROC dependencies on IGS_PE_PERSON_ID_TYP

Line 5886: igs_pe_person_id_typ pit

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)
5890: AND api.api_person_id_uf = lv_ssn ;