872: WHERE sca.person_id = sua.person_id
873: AND sca.course_cd = sua.course_cd
874: AND sca.progression_status = gas.progression_status)
875: OR EXISTS ( SELECT 'x'
876: FROM igs_pe_prsid_grp_mem pigm,
877: igs_as_gpc_pe_id_grp gpg
878: WHERE sua.person_id = pigm.person_id
879: AND pigm.GROUP_ID = gpg.GROUP_ID)
880: OR EXISTS ( SELECT 'x'
940: WHERE sca.person_id = sua.person_id
941: AND sca.course_cd = sua.course_cd
942: AND sca.progression_status = gas.progression_status)
943: OR EXISTS ( SELECT 'x'
944: FROM igs_pe_prsid_grp_mem pigm,
945: igs_as_gpc_pe_id_grp gpg
946: WHERE sua.person_id = pigm.person_id
947: AND pigm.GROUP_ID = gpg.GROUP_ID)
948: OR EXISTS ( SELECT 'x'