APPS.CN_RULE_ATTR_EXPR dependencies on CN_RULE_ATTR_EXPRESSION

Line 8: (x_rule_id IN cn_rule_attr_expression.rule_id%TYPE) IS

4: -- Procedure Name: delete_expr --
5: -- Purpose --
6: --------------------------------------------------------------------------
7: PROCEDURE delete_expr
8: (x_rule_id IN cn_rule_attr_expression.rule_id%TYPE) IS
9: BEGIN
10:
11: UPDATE cn_attribute_rules
12: SET expression = ''

Line 15: DELETE FROM cn_rule_attr_expression

11: UPDATE cn_attribute_rules
12: SET expression = ''
13: WHERE rule_id = x_rule_id;
14:
15: DELETE FROM cn_rule_attr_expression
16: WHERE rule_id = x_rule_id;
17:
18: commit;
19: