888: sua.cal_type,
889: sua.ci_sequence_number
890: ))
891: OR EXISTS ( SELECT 'x'
892: FROM igs_as_su_setatmpt iass,
893: igs_as_gpc_unit_sets gus
894: WHERE iass.person_id = sua.person_id
895: AND iass.course_cd = sua.course_cd
896: AND iass.unit_set_cd = gus.unit_set_cd)
956: sua.cal_type,
957: sua.ci_sequence_number
958: ))
959: OR EXISTS ( SELECT 'x'
960: FROM igs_as_su_setatmpt iass,
961: igs_as_gpc_unit_sets gus
962: WHERE iass.person_id = sua.person_id
963: AND iass.course_cd = sua.course_cd
964: AND iass.unit_set_cd = gus.unit_set_cd)