APPS.IGS_AS_GEN_005 dependencies on IGS_AS_UNIT_CLASS

Line 789: igs_as_unit_class uc

785: sua.unit_class,
786: uc.unit_mode,
787: sua.uoo_id
788: FROM igs_en_su_attempt_all sua,
789: igs_as_unit_class uc
790: WHERE sua.uoo_id = NVL(p_uoo_id,sua.uoo_id) AND
791: sua.unit_cd = p_unit_cd
792: AND sua.cal_type = p_cal_type
793: AND sua.ci_sequence_number = p_ci_sequence_number

Line 903: -- Select all students within the IGS_PS_UNIT, IGS_AD_LOCATION, IGS_AS_UNIT_MODE, IGS_AS_UNIT_CLASS and

899: END IF;
900: ELSE
901: CLOSE cur_as_prg_type;
902: END IF;
903: -- Select all students within the IGS_PS_UNIT, IGS_AD_LOCATION, IGS_AS_UNIT_MODE, IGS_AS_UNIT_CLASS and
904: -- attempt to add the assessment item via the module call. Ignore any message
905: -- if fails to insert, as it will mean the student already has the item or is
906: -- not suppose to have it anyway.The student must be ENROLLED within the unit.
907: FOR v_sua_rec IN c_sua LOOP