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_CANCEL_RECONSIDER dependencies on IGS_AD_SS_APPL_TYP

Line 372: CURSOR c_admission_type (cp_admission_type IGS_AD_SS_APPL_TYP.ADMISSION_APPLICATION_TYPE%TYPE) IS

368: AND NVL(adm_outcome_status,'PENDING') <> 'PENDING';
369:
370: l_get_pending_hist_rec c_get_pending_hist%ROWTYPE;
371:
372: CURSOR c_admission_type (cp_admission_type IGS_AD_SS_APPL_TYP.ADMISSION_APPLICATION_TYPE%TYPE) IS
373: SELECT admission_cat, s_admission_process_type
374: FROM igs_ad_ss_appl_typ
375: WHERE admission_application_type = cp_admission_type;
376:

Line 374: FROM igs_ad_ss_appl_typ

370: l_get_pending_hist_rec c_get_pending_hist%ROWTYPE;
371:
372: CURSOR c_admission_type (cp_admission_type IGS_AD_SS_APPL_TYP.ADMISSION_APPLICATION_TYPE%TYPE) IS
373: SELECT admission_cat, s_admission_process_type
374: FROM igs_ad_ss_appl_typ
375: WHERE admission_application_type = cp_admission_type;
376:
377: l_admission_type c_admission_type%ROWTYPE;
378: