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: