APPS.IGS_EN_TIMESLOTS dependencies on IGS_EN_STDNT_PS_INTM

Line 1929: EXISTS (SELECT 'X' FROM igs_en_stdnt_ps_intm sci, igs_en_intm_types eit WHERE

1925: pt.course_type_group_cd = p_prg_type_gr_cd AND
1926: ( sca.course_attempt_status = 'ENROLLED'
1927: OR
1928: ( sca.course_attempt_status = 'INTERMIT' AND
1929: EXISTS (SELECT 'X' FROM igs_en_stdnt_ps_intm sci, igs_en_intm_types eit WHERE
1930: sci.end_dt < p_start_dt AND
1931: sci.logical_delete_date = TO_DATE('31-12-4712','DD-MM-YYYY') AND
1932: sca.person_id = sci.person_id AND
1933: sca.course_cd = sci.course_cd AND