571: (select 'Y' from IGS_AD_TRANSCRIPT
572: yy where yy.EDUCATION_ID=xx.EDUCATION_ID
573: ))
574:
575: or exists (select 'Y' from IGS_PE_HZ_PARTIES xx where xx.PARTY_ID = temp.party_id
576: )
577:
578: or exists (select 'Y' from IGS_FI_CREDITS_ALL xx where xx.PARTY_ID = temp.party_id
579: )
651: (select 'Y' from IGS_AD_TRANSCRIPT
652: yy where yy.EDUCATION_ID=xx.EDUCATION_ID
653: ))
654:
655: or exists (select 'Y' from IGS_PE_HZ_PARTIES xx where xx.PARTY_ID = temp.party_id
656: )
657:
658: or exists (select 'Y' from IGS_FI_CREDITS_ALL xx where xx.PARTY_ID = temp.party_id
659: )