APPS.IGS_AD_VAL_ACAIU dependencies on IGS_AD_PS_APPL_INST

Line 30: FROM IGS_AD_PS_APPL_INST acai,

26: aa.admission_appl_number= p_admission_appl_number AND
27: aa.adm_appl_status = aas.adm_appl_status;
28: CURSOR c_acai_aos IS
29: SELECT aos.s_adm_outcome_status
30: FROM IGS_AD_PS_APPL_INST acai,
31: IGS_AD_OU_STAT aos
32: WHERE acai.person_id = p_person_id AND
33: acai.admission_appl_number = p_admission_appl_number AND
34: acai.nominated_course_cd = p_nominated_course_cd AND

Line 425: FROM IGS_AD_PS_APPL_INST acai,

421: v_s_adm_outcome_status_aos IGS_AD_OU_STAT.s_adm_outcome_status%TYPE;
422: v_s_adm_outcome_status_auos IGS_AD_UNIT_OU_STAT.s_adm_outcome_status%TYPE;
423: CURSOR c_aos IS
424: SELECT aos.s_adm_outcome_status
425: FROM IGS_AD_PS_APPL_INST acai,
426: IGS_AD_OU_STAT aos
427: WHERE acai.adm_outcome_status = aos.adm_outcome_status AND
428: acai.person_id = p_person_id AND
429: acai.admission_appl_number = p_admission_appl_number AND