APPS.IGS_UC_EXPORT_DECISION_REPLY dependencies on IGS_AD_CODE_CLASSES

Line 26: jchakrab 03-Oct-2005 Modified for 4506750 Impact - added extra filter for IGS_AD_CODE_CLASSES.class_type_code

22: variables used to compare the academic and admissions calendars for bug:2708981
23: ayedubat 26-MAR-2003 Changed the procedure to create a new cursor,c_ch_system which is used to
24: create the Decision Import batch ids only for the Systems for which atleast
25: one Application Choice Record exist for the bug: 2669209
26: jchakrab 03-Oct-2005 Modified for 4506750 Impact - added extra filter for IGS_AD_CODE_CLASSES.class_type_code
27: jchin 20-jan-06 Modified for R12 Perf improvements - Bug 3691277 and 3691250
28: jchakrab 22-May-06 Modified for 5165624
29: ******************************************************************/
30:

Line 281: FROM igs_ad_code_classes

277: -- Cursor to fetch the default Pending Reason
278: -- used when the Bulk reject reset by UCAS to PENDING
279: CURSOR cur_pending_reason IS
280: SELECT code_id
281: FROM igs_ad_code_classes
282: WHERE class = 'PENDING_REASON'
283: AND system_default = 'Y'
284: AND class_type_code = 'ADM_CODE_CLASSES';
285: cur_pending_reason_rec cur_pending_reason%ROWTYPE ;