APPS.IGF_SP_CREATE_BASE_REC dependencies on IGS_PE_ALT_PERS_ID

Line 411: FROM igs_pe_alt_pers_id

407:
408: -- cursor to get the ssn no of a person
409: CURSOR ssn_cur(cp_person_id number) IS
410: SELECT api_person_id,api_person_id_uf, end_dt
411: FROM igs_pe_alt_pers_id
412: WHERE pe_person_id=cp_person_id
413: AND person_id_type like 'SSN'
414: AND SYSDATE < = NVL(end_dt,SYSDATE);
415: