59:
60: or exists (select 'Y' from PV_LEAD_ASSIGNMENTS xx where xx.PARTNER_ID = temp.party_id
61: )
62:
63: or exists (select 'Y' from PV_ASSIGNMENT_LOGS xx where xx.PARTNER_ID = temp.party_id
64: )
65:
66: or exists (select 'Y' from PV_SEARCH_ATTR_VALUES xx where xx.PARTY_ID = temp.party_id
67: )
158:
159: or exists (select 'Y' from PV_LEAD_ASSIGNMENTS xx where xx.PARTNER_ID = temp.party_id
160: )
161:
162: or exists (select 'Y' from PV_ASSIGNMENT_LOGS xx where xx.PARTNER_ID = temp.party_id
163: )
164:
165: or exists (select 'Y' from PV_SEARCH_ATTR_VALUES xx where xx.PARTY_ID = temp.party_id
166: )