APPS.IGS_RU_VAL_UNIT_RULE dependencies on IGS_EN_SU_ATTEMPT

Line 35: AND EXISTS ( SELECT 1 FROM igs_en_su_attempt su

31: SELECT ps.course_cd , ps.version_number
32: FROM igs_en_stdnt_ps_att ps
33: WHERE ps.person_id = cp_person_id
34: AND ps.course_attempt_status IN ('ENROLLED' ,'INACTIVE')
35: AND EXISTS ( SELECT 1 FROM igs_en_su_attempt su
36: WHERE su.person_id=ps.person_id
37: AND su.course_cd =ps.course_cd )
38: ORDER BY course_cd desc;
39: