DBA Data[Home] [Help]

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 ;