APPS.IGS_EN_VAL_SCA dependencies on IGS_AS_SU_STMPTOUT

Line 1924: FROM IGS_AS_SU_STMPTOUT suao,

1920: sua.unit_attempt_status = cst_enrolled;
1921: v_sua_enr_exists VARCHAR2(1);
1922: CURSOR c_sua_comp IS
1923: SELECT 'x'
1924: FROM IGS_AS_SU_STMPTOUT suao,
1925: IGS_EN_SU_ATTEMPT sua
1926: WHERE sua.person_id = p_person_id AND
1927: sua.course_cd = p_course_cd AND
1928: sua.unit_attempt_status = cst_completed AND