DBA Data[Home] [Help]

APPS.HZ_DQM_DUP_ID_PKG dependencies on HZ_MATCH_RULE_PRIMARY

Line 2113: FROM hz_match_rule_primary p, 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
2113: FROM hz_match_rule_primary p, hz_trans_attributes_vl a
2114: WHERE a.attribute_id = p.attribute_id
2115: AND p.match_rule_id = p_match_rule_id;
2116:
2117: CURSOR check_inactive IS

Line 2119: FROM hz_match_rule_primary p, hz_primary_trans pt, hz_trans_functions_vl f

2115: AND p.match_rule_id = p_match_rule_id;
2116:
2117: CURSOR check_inactive IS
2118: SELECT 1
2119: FROM hz_match_rule_primary p, hz_primary_trans pt, hz_trans_functions_vl f
2120: WHERE p.match_rule_id = p_match_rule_id
2121: AND pt.PRIMARY_ATTRIBUTE_ID = p.PRIMARY_ATTRIBUTE_ID
2122: AND f.function_id = pt.function_id
2123: AND nvl(f.ACTIVE_FLAG,'Y') = 'N'