2003:
2004: or exists (select 'Y' from OKL_CNSLD_AR_HDRS_B xx where xx.IBT_ID = temp.party_id
2005: )
2006:
2007: or exists (select 'Y' from OKL_TXL_RCPT_APPS_B xx where xx.ILE_ID = temp.party_id
2008: )
2009:
2010: or exists (select 'Y' from HZ_CONTACT_POINTS
2011: xx where xx.OWNER_TABLE_ID = temp.party_id
2052:
2053: or exists (select 'Y' from OKL_CNSLD_AR_HDRS_B xx where xx.IBT_ID = temp.party_id
2054: )
2055:
2056: or exists (select 'Y' from OKL_TXL_RCPT_APPS_B xx where xx.ILE_ID = temp.party_id
2057: )
2058:
2059: or exists (select 'Y' from HZ_CONTACT_POINTS
2060: xx where xx.OWNER_TABLE_ID = temp.party_id