APPS.IGS_AD_VAL_ACAI dependencies on IGS_PE_ALT_PERS_ID
Line 151: igs_pe_alt_pers_id
147: CURSOR c_igs_pe_ucas(cp_n_person_id igs_pe_person.person_id%TYPE) IS
148: SELECT
149: api_person_id
150: FROM 151: igs_pe_alt_pers_id 152: WHERE
153: sysdate BETWEEN start_dt AND NVL(end_dt, sysdate)
154: AND person_id_type = 'UCASID'
155: AND pe_person_id = cp_n_person_id ;