APPS.IGS_AD_VAL_AA dependencies on IGS_AD_OFR_RESP_STAT

Line 573: IGS_AD_OFR_RESP_STAT aors

569: SELECT aos.s_adm_outcome_status,
570: aors.s_adm_offer_resp_status
571: FROM IGS_AD_PS_APPL_INST acai,
572: IGS_AD_OU_STAT aos,
573: IGS_AD_OFR_RESP_STAT aors
574: WHERE acai.person_id = p_person_id AND
575: acai.admission_appl_number = p_admission_appl_number AND
576: aos.adm_outcome_status = acai.adm_outcome_status AND
577: aors.adm_offer_resp_status = acai.adm_offer_resp_status;