APPS.IGF_AP_LI_ISIR_IMP_PROC dependencies on IGS_PE_PERSON_ID_TYP

Line 5981: igs_pe_person_id_typ pit

5977:
5978: SELECT 'SSN' rec_type,
5979: api.pe_person_id person_id
5980: FROM igs_pe_alt_pers_id api,
5981: igs_pe_person_id_typ pit
5982: WHERE api.person_id_type = pit.person_id_type
5983: AND pit.s_person_id_type = 'SSN'
5984: AND SYSDATE between api.start_dt AND NVL(api.end_dt,SYSDATE)
5985: AND api.api_person_id_uf = lv_ssn ;