APPS.IGS_AD_VAL_ACAI_STATUS dependencies on IGS_AD_PS_APLINSTUNT

Line 2168: FROM IGS_AD_PS_APLINSTUNT acaiu,

2164: acai.adm_outcome_status = aos.adm_outcome_status AND
2165: aos.s_adm_outcome_status <> cst_pending;
2166: CURSOR c_acaiu_auos IS
2167: SELECT 'x'
2168: FROM IGS_AD_PS_APLINSTUNT acaiu,
2169: IGS_AD_UNIT_OU_STAT auos
2170: WHERE acaiu.person_id = p_person_id AND
2171: acaiu.admission_appl_number = p_admission_appl_number AND
2172: acaiu.nominated_course_cd = p_nominated_course_cd AND