APPS.IGS_AD_PS_APPL_INST_PKG dependencies on IGS_PE_ALT_PERS_ID

Line 7068: FROM igs_pe_alt_pers_id

7064:
7065:
7066: CURSOR c_igs_pe_ucas(cp_n_person_id igs_pe_person.person_id%TYPE) IS
7067: SELECT api_person_id
7068: FROM igs_pe_alt_pers_id
7069: WHERE sysdate BETWEEN start_dt AND NVL(end_dt, sysdate)
7070: AND person_id_type IN ('UCASID', 'SWASID', 'NMASID', 'GTTRID')
7071: AND pe_person_id = cp_n_person_id ;
7072: rec_c_igs_pe_ucas c_igs_pe_ucas%ROWTYPE;