APPS.IGS_PR_GEN_006 dependencies on IGS_EN_SU_ATTEMPT

Line 331: FROM IGS_EN_SU_ATTEMPT sua,

327: p_person_id,
328: p_course_cd) = 'Y') AND
329: EXISTS (
330: SELECT 'x'
331: FROM IGS_EN_SU_ATTEMPT sua,
332: IGS_CA_INST_REL cir
333: WHERE sua.person_id = p_person_id AND
334: sua.course_cd = p_coursE_cd AND
335: sua.unit_attempt_status IN ('ENROLLED','COMPLETED','DISCONTIN') AND