2092:
2093: or exists (select 'Y' from AMS_ACT_PARTNERS xx where xx.PRIMARY_CONTACT_ID = temp.party_id
2094: )
2095:
2096: or exists (select 'Y' from AMS_EVENT_REGISTRATIONS xx where xx.REGISTRANT_PARTY_ID = temp.party_id
2097: )
2098:
2099: or exists (select 'Y' from AMS_EVENT_REGISTRATIONS xx where xx.ATTENDANT_CONTACT_ID = temp.party_id
2100: )
2095:
2096: or exists (select 'Y' from AMS_EVENT_REGISTRATIONS xx where xx.REGISTRANT_PARTY_ID = temp.party_id
2097: )
2098:
2099: or exists (select 'Y' from AMS_EVENT_REGISTRATIONS xx where xx.ATTENDANT_CONTACT_ID = temp.party_id
2100: )
2101:
2102: or exists (select 'Y' from AMS_CHANNELS_B xx where xx.PARTY_ID = temp.party_id
2103: )
2143:
2144: or exists (select 'Y' from AMS_ACT_PARTNERS xx where xx.PRIMARY_CONTACT_ID = temp.party_id
2145: )
2146:
2147: or exists (select 'Y' from AMS_EVENT_REGISTRATIONS xx where xx.REGISTRANT_PARTY_ID = temp.party_id
2148: )
2149:
2150: or exists (select 'Y' from AMS_EVENT_REGISTRATIONS xx where xx.ATTENDANT_CONTACT_ID = temp.party_id
2151: )
2146:
2147: or exists (select 'Y' from AMS_EVENT_REGISTRATIONS xx where xx.REGISTRANT_PARTY_ID = temp.party_id
2148: )
2149:
2150: or exists (select 'Y' from AMS_EVENT_REGISTRATIONS xx where xx.ATTENDANT_CONTACT_ID = temp.party_id
2151: )
2152:
2153: or exists (select 'Y' from AMS_CHANNELS_B xx where xx.PARTY_ID = temp.party_id
2154: )