423:
424: or exists (select 'Y' from OZF_CLAIMS_ALL xx where xx.CONTACT_ID = temp.party_id
425: )
426:
427: or exists (select 'Y' from OZF_ACT_BUDGETS xx where xx.BUDGET_SOURCE_ID = temp.party_id
428: and (BUDGET_SOURCE_TYPE='PTNR'))
429:
430: or exists (select 'Y' from OZF_ACT_BUDGETS xx where xx.VENDOR_ID = temp.party_id
431: )
426:
427: or exists (select 'Y' from OZF_ACT_BUDGETS xx where xx.BUDGET_SOURCE_ID = temp.party_id
428: and (BUDGET_SOURCE_TYPE='PTNR'))
429:
430: or exists (select 'Y' from OZF_ACT_BUDGETS xx where xx.VENDOR_ID = temp.party_id
431: )
432:
433: or exists (select 'Y' from OZF_OFFERS xx where xx.BUYING_GROUP_CONTACT_ID = temp.party_id
434: )
456:
457: or exists (select 'Y' from OZF_CLAIMS_ALL xx where xx.CONTACT_ID = temp.party_id
458: )
459:
460: or exists (select 'Y' from OZF_ACT_BUDGETS xx where xx.BUDGET_SOURCE_ID = temp.party_id
461: and (BUDGET_SOURCE_TYPE='PTNR'))
462:
463: or exists (select 'Y' from OZF_ACT_BUDGETS xx where xx.VENDOR_ID = temp.party_id
464: )
459:
460: or exists (select 'Y' from OZF_ACT_BUDGETS xx where xx.BUDGET_SOURCE_ID = temp.party_id
461: and (BUDGET_SOURCE_TYPE='PTNR'))
462:
463: or exists (select 'Y' from OZF_ACT_BUDGETS xx where xx.VENDOR_ID = temp.party_id
464: )
465:
466: or exists (select 'Y' from OZF_OFFERS xx where xx.BUYING_GROUP_CONTACT_ID = temp.party_id
467: )