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_009 dependencies on IGS_AD_OU_STAT

Line 223: v_adm_outcome_status IGS_AD_OU_STAT.adm_outcome_status%TYPE;

219: -- admp_get_sys_aos
220: -- Routine to return the user-defined system default admission outcome
221: -- status for given the system admission outcome status.
222: DECLARE
223: v_adm_outcome_status IGS_AD_OU_STAT.adm_outcome_status%TYPE;
224: CURSOR c_aos IS
225: SELECT aos.adm_outcome_status
226: FROM IGS_AD_OU_STAT aos
227: WHERE aos.s_adm_outcome_status = p_s_adm_outcome_status AND

Line 226: FROM IGS_AD_OU_STAT aos

222: DECLARE
223: v_adm_outcome_status IGS_AD_OU_STAT.adm_outcome_status%TYPE;
224: CURSOR c_aos IS
225: SELECT aos.adm_outcome_status
226: FROM IGS_AD_OU_STAT aos
227: WHERE aos.s_adm_outcome_status = p_s_adm_outcome_status AND
228: aos.system_default_ind = 'Y' AND
229: aos.closed_ind = 'N';
230: BEGIN