APPS.IGS_UC_TRX_GEN_HOOK dependencies on IGS_UC_DEFAULTS

Line 105: CURSOR system_name_cur ( p_system_code igs_uc_defaults.system_code%TYPE) IS

101: adm_outcome_status = p_adm_outcome_status AND
102: closed_ind = 'N';
103:
104: -- To Fetch the Name of the UCAS System
105: CURSOR system_name_cur ( p_system_code igs_uc_defaults.system_code%TYPE) IS
106: SELECT name
107: FROM igs_uc_defaults
108: WHERE system_code = p_system_code;
109:

Line 107: FROM igs_uc_defaults

103:
104: -- To Fetch the Name of the UCAS System
105: CURSOR system_name_cur ( p_system_code igs_uc_defaults.system_code%TYPE) IS
106: SELECT name
107: FROM igs_uc_defaults
108: WHERE system_code = p_system_code;
109:
110: app_clr_rnd_rec cur_app_clr_rnd%ROWTYPE;
111:

Line 119: l_system_name igs_uc_defaults.name%TYPE;

115: l_reply igs_uc_app_choices.reply%TYPE;
116: l_ucas_program_code igs_uc_app_choices.ucas_program_code%TYPE;
117: l_campus igs_uc_app_choices.campus%TYPE;
118: l_system_code igs_uc_cyc_defaults.system_code%TYPE;
119: l_system_name igs_uc_defaults.name%TYPE;
120: l_validate_error_cd igs_lookup_values.lookup_code%TYPE;
121: l_transaction_toy igs_uc_ucas_control.transaction_toy_code%TYPE;
122:
123: BEGIN