685: sua.ci_sequence_number ,
686: sua.unit_attempt_status ,
687: sua.discontinued_dt ,
688: sua.uoo_id
689: FROM IGS_EN_SU_ATTEMPT_ALL sua,
690: IGS_HE_ST_UNT_VS_ALL hsu,
691: IGS_PS_UNIT_OFR_OPT_ALL uoo
692: WHERE sua.person_id = cp_person_id
693: AND sua.course_cd = cp_course_cd
730: version_number,
731: ci_start_dt,
732: override_enrolled_cp ,
733: uoo_id
734: FROM igs_en_su_attempt_all
735: WHERE person_id = cp_person_id AND
736: course_cd = cp_course_cd AND
737: unit_attempt_status = cst_completed AND
738: (ci_start_dt BETWEEN p_fte_start_dt AND p_fte_end_dt) ;