APPS.HZ_MERGE_DUP_PVT dependencies on HZ_MATCH_RULES_VL

Line 2255: from HZ_MATCH_RULES_VL

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

Line 2259: from HZ_MATCH_RULES_VL

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