2235:
2236: or exists (select 'Y' from AMS_CHANNELS_B xx where xx.PARTY_ID = temp.party_id
2237: )
2238:
2239: or exists (select 'Y' from AMS_IBA_POSTINGS_B xx where xx.CUSTOMER_PARTY_ID = temp.party_id
2240: )
2241:
2242: or exists (select 'Y' from AMS_IBA_POSTINGS_B xx where xx.AFFILIATE_PARTY_ID = temp.party_id
2243: )
2238:
2239: or exists (select 'Y' from AMS_IBA_POSTINGS_B xx where xx.CUSTOMER_PARTY_ID = temp.party_id
2240: )
2241:
2242: or exists (select 'Y' from AMS_IBA_POSTINGS_B xx where xx.AFFILIATE_PARTY_ID = temp.party_id
2243: )
2244:
2245: or exists (select 'Y' from AMS_COMPETITOR_PRODUCTS_B xx where xx.COMPETITOR_PARTY_ID = temp.party_id
2246: )
2286:
2287: or exists (select 'Y' from AMS_CHANNELS_B xx where xx.PARTY_ID = temp.party_id
2288: )
2289:
2290: or exists (select 'Y' from AMS_IBA_POSTINGS_B xx where xx.CUSTOMER_PARTY_ID = temp.party_id
2291: )
2292:
2293: or exists (select 'Y' from AMS_IBA_POSTINGS_B xx where xx.AFFILIATE_PARTY_ID = temp.party_id
2294: )
2289:
2290: or exists (select 'Y' from AMS_IBA_POSTINGS_B xx where xx.CUSTOMER_PARTY_ID = temp.party_id
2291: )
2292:
2293: or exists (select 'Y' from AMS_IBA_POSTINGS_B xx where xx.AFFILIATE_PARTY_ID = temp.party_id
2294: )
2295:
2296: or exists (select 'Y' from AMS_COMPETITOR_PRODUCTS_B xx where xx.COMPETITOR_PARTY_ID = temp.party_id
2297: )