DBA Data[Home] [Help]

APPS.HZ_AUTOMERGE_PKG dependencies on HZ_MATCH_RULES_B

Line 281: from hz_dup_batch a, hz_match_rules_b b

277: -- log(' p_dup_batch_id = ' || p_dup_batch_id);
278: select a.dup_batch_name, a.match_rule_id,
279: decode(a.request_type, 'SYSTEM_GENERATED', 'SYSTEM_AUTOMERGE', 'IMPORT', 'IMPORT_AUTOMERGE'), a.request_type, b.automerge_flag
280: into l_batch_name, l_match_rule_id, l_req_type, l_request_type, l_automerge_flag
281: from hz_dup_batch a, hz_match_rules_b b
282: where a.dup_batch_id = p_dup_batch_id
283: and a.match_rule_id = b.match_rule_id;
284: -- log(' l_automerge_flag = ' || l_automerge_flag);
285: IF (upper(l_automerge_flag) <> 'Y') THEN