APPS.HZ_DQM_DUP_ID_PKG dependencies on HZ_MATCH_RULES_VL

Line 1065: from hz_match_rules_vl

1061:
1062:
1063: -- get the threshold and the auto merge threshold
1064: select match_score, auto_merge_score into x_threshold, x_auto_merge_threshold
1065: from hz_match_rules_vl
1066: where match_rule_id = p_match_rule_id;
1067:
1068: -- sanitize data in temp tables that get populated by the match rule
1069: sanitize_tca_dup_parties ( x_threshold, x_auto_merge_threshold, p_subset_sql,

Line 1220: from hz_match_rules_vl

1216: -- WE WANT TO IDENTIFY BATCHES THAT ARE AUTO MERGE ENABLED
1217:
1218: update hz_dup_batch
1219: set automerge_flag = (select automerge_flag
1220: from hz_match_rules_vl
1221: where match_rule_id = p_match_rule_id)
1222: where dup_batch_id = l_dup_batch_id ;
1223:
1224: -- NOTE: WINNERS ARE TCA PARTIES

Line 1510: from hz_match_rules_vl

1506: END IF;
1507:
1508: -- get the threshold and the auto merge threshold
1509: select match_score, auto_merge_score into x_threshold, x_auto_merge_threshold
1510: from hz_match_rules_vl
1511: where match_rule_id = p_match_rule_id;
1512:
1513: -- get the match rule package
1514: l_pkg_name := 'HZ_IMP_MATCH_RULE_'||p_match_rule_id;

Line 1981: from hz_match_rules_vl

1977: x_return_status := FND_API.G_RET_STS_SUCCESS;
1978:
1979: -- get the threshold
1980: select match_score into x_threshold
1981: from hz_match_rules_vl
1982: where match_rule_id = p_match_rule_id;
1983:
1984: -- get the match rule package
1985: l_pkg_name := 'HZ_IMP_MATCH_RULE_'||p_match_rule_id;

Line 2036: from hz_match_rules_vl

2032:
2033:
2034: -- get the threshold for the match rule
2035: select match_score into x_threshold
2036: from hz_match_rules_vl
2037: where match_rule_id = p_match_rule_id;
2038:
2039: -- sanitize party osrs
2040: sanitize_int_dup_party_osrs (x_threshold, p_batch_id);

Line 2151: FROM HZ_MATCH_RULES_VL

2147:
2148: BEGIN
2149: -- Verify that the match rule exists
2150: SELECT 1 INTO l_batch_flag
2151: FROM HZ_MATCH_RULES_VL
2152: WHERE match_rule_id = p_match_rule_id;
2153:
2154: EXCEPTION
2155: WHEN NO_DATA_FOUND THEN