2107:
2108: or exists (select 'Y' from AMS_IBA_POSTINGS_B xx where xx.AFFILIATE_PARTY_ID = temp.party_id
2109: )
2110:
2111: or exists (select 'Y' from AMS_COMPETITOR_PRODUCTS_B xx where xx.COMPETITOR_PARTY_ID = temp.party_id
2112: )
2113:
2114: or exists (select 'Y' from AMS_VENUES_B xx where xx.PARTY_ID = temp.party_id
2115: and (OBJECT_TYPE='VENU'))
2158:
2159: or exists (select 'Y' from AMS_IBA_POSTINGS_B xx where xx.AFFILIATE_PARTY_ID = temp.party_id
2160: )
2161:
2162: or exists (select 'Y' from AMS_COMPETITOR_PRODUCTS_B xx where xx.COMPETITOR_PARTY_ID = temp.party_id
2163: )
2164:
2165: or exists (select 'Y' from AMS_VENUES_B xx where xx.PARTY_ID = temp.party_id
2166: and (OBJECT_TYPE='VENU'))