APPS.IGS_AD_VAL_AA dependencies on IGS_AD_OU_STAT

Line 572: IGS_AD_OU_STAT aos,

568: CURSOR c_acai IS
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

Line 737: IGS_AD_OU_STAT aos

733: v_message_name VARCHAR2(30);
734: CURSOR c_chk_offer_pend IS
735: SELECT 'x'
736: FROM IGS_AD_PS_APPL_INST acai,
737: IGS_AD_OU_STAT aos
738: WHERE acai.person_id = p_person_id AND
739: acai.admission_appl_number = p_admission_appl_number AND
740: aos.s_adm_outcome_status IN (
741: cst_offer,

Line 749: IGS_AD_OU_STAT aos

745: acai.adm_outcome_status = aos.adm_outcome_status;
746: CURSOR c_chk_offer_ass IS
747: SELECT 'x'
748: FROM IGS_AD_PS_APPL_INST acai,
749: IGS_AD_OU_STAT aos
750: WHERE acai.person_id = p_person_id AND
751: acai.admission_appl_number = p_admission_appl_number AND
752: aos.s_adm_outcome_status = cst_offer AND
753: acai.adm_outcome_status = aos.adm_outcome_status;

Line 757: IGS_AD_OU_STAT aos

753: acai.adm_outcome_status = aos.adm_outcome_status;
754: CURSOR c_chk_cond_fee IS
755: SELECT 'x'
756: FROM IGS_AD_PS_APPL_INST acai,
757: IGS_AD_OU_STAT aos
758: WHERE acai.person_id = p_person_id AND
759: acai.admission_appl_number = p_admission_appl_number AND
760: aos.s_adm_outcome_status = cst_cond_offer AND
761: acai.adm_outcome_status = aos.adm_outcome_status;

Line 765: IGS_AD_OU_STAT aos,

761: acai.adm_outcome_status = aos.adm_outcome_status;
762: CURSOR c_check_cndtnl IS
763: SELECT 'x'
764: FROM IGS_AD_PS_APPL_INST acai,
765: IGS_AD_OU_STAT aos,
766: IGS_AD_CNDNL_OFRSTAT acos
767: WHERE acai.person_id = p_person_id AND
768: acai.admission_appl_number = p_admission_appl_number AND
769: aos.s_adm_outcome_status = cst_cond_offer AND