DBA Data[Home] [Help]

APPS.HZ_DQM_DUP_ID_PKG dependencies on HZ_MATCH_RULE_SECONDARY

Line 2108: FROM hz_match_rule_secondary s, hz_trans_attributes_vl a

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

Line 2126: FROM hz_match_rule_secondary s, hz_secondary_trans pt, hz_trans_functions_vl f

2122: AND f.function_id = pt.function_id
2123: AND nvl(f.ACTIVE_FLAG,'Y') = 'N'
2124: UNION
2125: SELECT 1
2126: FROM hz_match_rule_secondary s, hz_secondary_trans pt, hz_trans_functions_vl f
2127: WHERE s.match_rule_id = p_match_rule_id
2128: AND pt.SECONDARY_ATTRIBUTE_ID = s.SECONDARY_ATTRIBUTE_ID
2129: AND f.function_id = pt.function_id
2130: AND nvl(f.ACTIVE_FLAG,'Y') = 'N';