APPS.HZ_MATCH_RULES_PKG dependencies on HZ_MATCH_RULE_SECONDARY

Line 296: FROM HZ_MATCH_RULE_SECONDARY

292: -- Start of changes for Bug 3962742
293: --Delete associated entries in following entities
294: DELETE FROM HZ_SECONDARY_TRANS
295: WHERE secondary_attribute_id IN (SELECT secondary_attribute_id
296: FROM HZ_MATCH_RULE_SECONDARY
297: WHERE match_rule_id = X_MATCH_RULE_ID);
298:
299: DELETE FROM HZ_PRIMARY_TRANS
300: WHERE primary_attribute_id IN (SELECT primary_attribute_id

Line 304: DELETE FROM HZ_MATCH_RULE_SECONDARY

300: WHERE primary_attribute_id IN (SELECT primary_attribute_id
301: FROM HZ_MATCH_RULE_PRIMARY
302: WHERE match_rule_id = X_MATCH_RULE_ID);
303:
304: DELETE FROM HZ_MATCH_RULE_SECONDARY
305: WHERE MATCH_RULE_ID = X_MATCH_RULE_ID;
306:
307: DELETE FROM HZ_MATCH_RULE_PRIMARY
308: WHERE MATCH_RULE_ID = X_MATCH_RULE_ID;