APPS.IGS_EN_TIMESLOTS dependencies on IGS_EN_SU_ATTEMPT_ALL

Line 1997: (SELECT 'x' FROM igs_en_su_attempt_all sua

1993: pv2.course_cd = sca2.course_cd AND
1994: pv2.version_number = sca2.version_number AND
1995: sca2.course_attempt_status = 'INACTIVE' AND
1996: NOT EXISTS
1997: (SELECT 'x' FROM igs_en_su_attempt_all sua
1998: WHERE sua.person_id = sca2.person_id AND
1999: sua.course_cd = sca2.course_cd AND
2000: sua.course_cd = pv2.course_cd) AND
2001: igs_en_timeslots.acad_teach_rel_exist(sca2.cal_type,cp_cal_type,cp_seq_num) = 'TRUE' ;