[Home] [Help]
74: igs_ca_inst_all ci,
75: igs_ca_type ca,
76: igs_ca_stat cs,
77: igs_ca_inst_rel car,
78: igs_ps_ver_all pv
79: WHERE sca.person_id = cp_n_person_id
80: AND sca.course_cd = pv.course_cd
81: AND sca.version_number = pv.version_number
82: AND sca.course_attempt_status IN ('ENROLLED','INACTIVE', 'INTERMIT')