eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_GEN_012 dependencies on IGS_AD_OU_STAT

Line 292: WHERE EXISTS (SELECT 'x' from igs_ad_ou_stat aos

288:
289: CURSOR c_update_acai IS
290: SELECT acai.ROWID, acai.*
291: FROM IGS_AD_PS_APPL_INST acai
292: WHERE EXISTS (SELECT 'x' from igs_ad_ou_stat aos
293: WHERE aos.adm_outcome_status = acai.adm_outcome_status
294: AND aos.s_adm_outcome_status IN ( cst_offer, cst_cond_offer))
295: AND EXISTS (SELECT 'x' FROM igs_ad_ofr_resp_stat aors
296: WHERE aors.adm_offer_resp_status = acai.adm_offer_resp_status

Line 585: AND EXISTS (SELECT 'x' FROM igs_ad_ou_stat aos

581: AND aa.admission_appl_number = acaiv.admission_appl_number
582: AND acaiv.person_id = cp_person_id
583: AND acaiv.admission_appl_number = cp_admission_appl_number
584: AND acaiv.nominated_course_cd = cp_nominated_course_cd
585: AND EXISTS (SELECT 'x' FROM igs_ad_ou_stat aos
586: WHERE aos.adm_outcome_status = acaiv.adm_outcome_status
587: AND aos.s_adm_outcome_status IN (cst_rejected, cst_no_quota))
588: AND EXISTS (SELECT 'x' FROM igs_ca_inst ci
589: WHERE ci.cal_type = NVL (acaiv.adm_cal_type,aa.adm_cal_type)

Line 633: v_adm_outcome_status IGS_AD_OU_STAT.adm_outcome_status%TYPE;

629: v_late_ind VARCHAR2(1);
630: v_aca_exists VARCHAR2(1);
631: v_acai_exists VARCHAR2(1);
632: v_acai_updated VARCHAR2(1) DEFAULT 'N';
633: v_adm_outcome_status IGS_AD_OU_STAT.adm_outcome_status%TYPE;
634: v_adm_cndtnl_offer_status IGS_AD_CNDNL_OFRSTAT.adm_cndtnl_offer_status%TYPE;
635: v_late_adm_fee_status IGS_AD_FEE_STAT.adm_fee_status%TYPE;
636: v_crv_version_number NUMBER;
637: v_course_start_dt IGS_CA_DA_INST_V.alias_val%TYPE;