280: where entity_name = 'CONTACTS'
281: and attribute_name = 'CONTACT_NAME'
282: and attribute_id in (
283: select attribute_id
284: from hz_match_rule_primary b
285: where match_rule_id = 50
286: union
287: select attribute_id
288: from hz_match_rule_secondary b
585: where entity_name = 'CONTACTS'
586: and attribute_name = 'CONTACT_NAME'
587: and attribute_id in (
588: select attribute_id
589: from hz_match_rule_primary b
590: where match_rule_id = 50
591: union
592: select attribute_id
593: from hz_match_rule_secondary b