APPS.HZ_MERGE_DUP_PVT dependencies on HZ_MATCH_RULES_VL

Line 2256: from HZ_MATCH_RULES_VL

2252:
2253: -- get match_rule_id from profile
2254:
2255: select min(match_rule_id) into l_default_addr_rule
2256: from HZ_MATCH_RULES_VL
2257: where rule_name = 'DL ADDRESS DEFAULT';
2258:
2259: select min(match_rule_id) into l_default_relat_rule
2260: from HZ_MATCH_RULES_VL

Line 2260: from HZ_MATCH_RULES_VL

2256: from HZ_MATCH_RULES_VL
2257: where rule_name = 'DL ADDRESS DEFAULT';
2258:
2259: select min(match_rule_id) into l_default_relat_rule
2260: from HZ_MATCH_RULES_VL
2261: where rule_name = 'DL RELATIONSHIP DEFAULT';
2262:
2263: l_addr_match_rule := nvl(fnd_profile.value('HZ_SUGG_ADDR_MATCH_RULE'),l_default_addr_rule);
2264: l_reln_match_rule := nvl(fnd_profile.value('HZ_SUGG_RELN_MATCH_RULE'),l_default_relat_rule);