2104: ) IS
2105:
2106: CURSOR check_null_set IS
2107: SELECT DISTINCT a.entity_name
2108: FROM hz_match_rule_secondary s, hz_trans_attributes_vl a
2109: WHERE a.attribute_id = s.attribute_id
2110: AND s.match_rule_id = p_match_rule_id
2111: MINUS
2112: SELECT DISTINCT a.entity_name
2109: WHERE a.attribute_id = s.attribute_id
2110: AND s.match_rule_id = p_match_rule_id
2111: MINUS
2112: SELECT DISTINCT a.entity_name
2113: FROM hz_match_rule_primary p, hz_trans_attributes_vl a
2114: WHERE a.attribute_id = p.attribute_id
2115: AND p.match_rule_id = p_match_rule_id;
2116:
2117: CURSOR check_inactive IS