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_014 dependencies on IGS_AD_APPL_ALL

Line 1907: SELECT ADMISSION_CAT, S_ADMISSION_PROCESS_TYPE FROM IGS_AD_APPL_ALL

1903: l_errbuf VARCHAR2(2000);
1904: l_retcode NUMBER;
1905:
1906: CURSOR c_adm_cat(cp_person_id IN NUMBER, cp_admission_Appl_number IN NUMBER) IS
1907: SELECT ADMISSION_CAT, S_ADMISSION_PROCESS_TYPE FROM IGS_AD_APPL_ALL
1908: WHERE PERSON_ID = cp_person_id AND ADMISSION_APPL_NUMBER = cp_admission_Appl_number;
1909:
1910: l_adm_cat_rec c_adm_cat%ROWTYPE;
1911:

Line 2006: SELECT ADMISSION_CAT, S_ADMISSION_PROCESS_TYPE FROM IGS_AD_APPL_ALL

2002: ) IS
2003:
2004: l_rowid ROWID;
2005: CURSOR c_adm_cat(cp_person_id IN NUMBER, cp_admission_Appl_number IN NUMBER) IS
2006: SELECT ADMISSION_CAT, S_ADMISSION_PROCESS_TYPE FROM IGS_AD_APPL_ALL
2007: WHERE PERSON_ID = cp_person_id AND ADMISSION_APPL_NUMBER = cp_admission_Appl_number;
2008:
2009: l_adm_cat_rec c_adm_cat%ROWTYPE;
2010: