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_EXPUNGE_APP dependencies on IGS_UC_DEFAULTS

Line 173: FROM igs_uc_defaults def,

169:
170: --To check whether the setup record is available FOR each System, which has an application to be expunged.
171: CURSOR cur_system_setup IS
172: SELECT 'X'
173: FROM igs_uc_defaults def,
174: igs_uc_applicants ucap
175: WHERE def.system_code (+) = ucap.system_code
176: AND def.system_code IS NULL
177: AND ucap.app_no IN ( SELECT app_no

Line 186: FROM igs_uc_defaults def

182:
183: --To check whether the all required values available in each UCAS Setup FOR the System, which has an application to be expunged.
184: CURSOR cur_system_val_setup IS
185: SELECT 'X'
186: FROM igs_uc_defaults def
187: WHERE system_code IN ( SELECT DISTINCT system_code
188: FROM igs_uc_applicants ucap,
189: igs_uc_wrong_app wap
190: WHERE ucap.app_no = wap.app_no

Line 209: FROM igs_uc_defaults def,

205: CURSOR cur_defaults (cp_app_no igs_uc_wrong_app.app_no%TYPE) IS
206: SELECT obsolete_outcome_status,
207: decision_make_id,
208: decision_reason_id
209: FROM igs_uc_defaults def,
210: igs_uc_applicants ucap
211: WHERE def.system_code = ucap.system_code
212: AND ucap.app_no = cp_app_no;
213: