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_UC_TRX_GEN_HOOK dependencies on IGS_UC_APPLICANTS

Line 70: CURSOR cur_system_code(cp_appno igs_uc_applicants.app_no%TYPE) IS

66: AND choice_no = cp_choice_no
67: AND ucas_cycle = cp_ucas_cycle;
68:
69: -- Get the system code using the alternate application id (appno)
70: CURSOR cur_system_code(cp_appno igs_uc_applicants.app_no%TYPE) IS
71: SELECT system_code FROM igs_uc_applicants WHERE app_no = cp_appno;
72:
73: -- Check whether clearing flag is set for the system
74: CURSOR cur_clearing (cp_system_code igs_uc_cyc_defaults.system_code%TYPE,

Line 71: SELECT system_code FROM igs_uc_applicants WHERE app_no = cp_appno;

67: AND ucas_cycle = cp_ucas_cycle;
68:
69: -- Get the system code using the alternate application id (appno)
70: CURSOR cur_system_code(cp_appno igs_uc_applicants.app_no%TYPE) IS
71: SELECT system_code FROM igs_uc_applicants WHERE app_no = cp_appno;
72:
73: -- Check whether clearing flag is set for the system
74: CURSOR cur_clearing (cp_system_code igs_uc_cyc_defaults.system_code%TYPE,
75: cp_ucas_cycle igs_uc_cyc_defaults.ucas_cycle%TYPE ) IS