APPS.IGS_EN_GEN_006 dependencies on IGS_AS_UNIT_MODE

Line 161: IGS_AS_UNIT_MODE um

157: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
158: SELECT um.s_unit_mode
159: FROM IGS_EN_SU_ATTEMPT sua,
160: IGS_AS_UNIT_CLASS ucl,
161: IGS_AS_UNIT_MODE um
162: WHERE sua.person_id = p_person_id AND
163: sua.course_cd = p_course_cd AND
164: sua.unit_attempt_status IN (
165: cst_enrolled,