APPS.IGF_AP_LI_BASE_REC_IMPORT dependencies on IGS_PE_ALT_PERS_ID

Line 287: FROM igs_pe_alt_pers_id

283:
284: -- cursor to get the ssn no of a person
285: CURSOR ssn_cur(cp_person_id number) IS
286: SELECT api_person_id,api_person_id_uf, end_dt
287: FROM igs_pe_alt_pers_id
288: WHERE pe_person_id=cp_person_id
289: AND person_id_type like 'SSN'
290: AND SYSDATE < = NVL(end_dt,SYSDATE);
291: