APPS.IGS_EN_VAL_SCI dependencies on IGS_EN_SU_ATTEMPT

Line 29: FROM IGS_EN_SU_ATTEMPT

25: cp_person_id IGS_EN_STDNT_PS_INTM.person_id%TYPE,
26: cp_course_cd IGS_EN_STDNT_PS_INTM.course_cd%TYPE) IS
27: SELECT cal_type,
28: ci_sequence_number
29: FROM IGS_EN_SU_ATTEMPT
30: WHERE person_id = cp_person_id AND
31: course_cd = cp_course_cd AND
32: unit_attempt_status NOT IN ('UNCONFIRM',
33: 'INVALID',

Line 181: FROM IGS_EN_SU_ATTEMPT

177: CURSOR c_sca_count
178: (cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
179: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
180: SELECT count(*)
181: FROM IGS_EN_SU_ATTEMPT
182: WHERE person_id = cp_person_id AND
183: course_cd = cp_course_cd AND
184: unit_attempt_status = 'COMPLETED';
185: BEGIN