APPS.IGS_AD_IMP_ADM_DES dependencies on IGS_AD_CODE_CLASSES

Line 132: CURSOR c_code_classes (cp_class igs_ad_code_classes.class%TYPE,

128: AND admission_appl_number = cp_admission_appl_number;
129:
130: l_appl_dt igs_ad_appl.appl_dt%TYPE;
131:
132: CURSOR c_code_classes (cp_class igs_ad_code_classes.class%TYPE,
133: cp_code_id igs_ad_code_classes.code_id%TYPE) IS
134: SELECT 'x'
135: FROM igs_ad_code_classes
136: WHERE code_id = cp_code_id

Line 133: cp_code_id igs_ad_code_classes.code_id%TYPE) IS

129:
130: l_appl_dt igs_ad_appl.appl_dt%TYPE;
131:
132: CURSOR c_code_classes (cp_class igs_ad_code_classes.class%TYPE,
133: cp_code_id igs_ad_code_classes.code_id%TYPE) IS
134: SELECT 'x'
135: FROM igs_ad_code_classes
136: WHERE code_id = cp_code_id
137: AND class = cp_class

Line 135: FROM igs_ad_code_classes

131:
132: CURSOR c_code_classes (cp_class igs_ad_code_classes.class%TYPE,
133: cp_code_id igs_ad_code_classes.code_id%TYPE) IS
134: SELECT 'x'
135: FROM igs_ad_code_classes
136: WHERE code_id = cp_code_id
137: AND class = cp_class
138: AND closed_ind = 'N';
139: