APPS.CN_RULES_DISP_PUB dependencies on CN_ATTRIBUTE_RULES

Line 83: FROM cn_attribute_rules cnattr, cn_objects cnobj,

79: SELECT cnobj.user_name object_name,
80: cnh.name hierarchy_name, cnattr.column_value column_value,
81: cnattr.not_flag not_flag, cnattr.high_value high_value,
82: cnattr.low_value low_value , cnattr.dimension_hierarchy_id dimension_hierarchy_id
83: FROM cn_attribute_rules cnattr, cn_objects cnobj,
84: cn_head_hierarchies cnh
85: WHERE cnattr.rule_id = l_rule_id
86: AND cnattr.ruleset_id = l_ruleset_id
87: AND cnattr.column_id = cnobj.object_id (+)

Line 175: FROM CN_ATTRIBUTE_RULES

171: -- for user created expressions
172:
173: SELECT DISTINCT expression
174: INTO x_rules_display_tbl(x_rules_count).rule_expression
175: FROM CN_ATTRIBUTE_RULES
176: WHERE RULE_ID = rules.rule_id ;
177:
178: ELSE
179: -- for expression not 'created' by the user

Line 253: FROM CN_ATTRIBUTE_RULES

249: -- for user created expressions
250:
251: SELECT DISTINCT expression
252: INTO x_rules_display_tbl(x_rules_count).rule_expression
253: FROM CN_ATTRIBUTE_RULES
254: WHERE RULE_ID = rules.rule_id ;
255:
256: ELSE
257: -- for expression not 'created' by the user