96: -- only for items that have not been deleted
97: DECLARE
98: CURSOR c_uai IS
99: SELECT 'x'
100: FROM igs_ps_unitass_item uai,
101: IGS_AS_ASSESSMNT_ITM ai,
102: IGS_AS_ASSESSMNT_TYP atyp,
103: igs_ps_unit_ofr_opt uoo
104: WHERE atyp.examinable_ind = 'N' AND
176: CURSOR c_uai IS
177: SELECT 'x'
178: FROM IGS_AS_ASSESSMNT_TYP atyp,
179: IGS_AS_ASSESSMNT_ITM ai,
180: igs_ps_unitass_item uai,
181: igs_ps_unit_ofr_opt uoo
182: WHERE atyp.examinable_ind = 'Y' AND
183: ai.assessment_type = atyp.assessment_type AND
184: uai.ass_id = ai.ass_id AND