APPS.CN_RULE_PVT dependencies on CN_ATTRIBUTE_RULES

Line 898: FROM cn_attribute_rules car

894: CONNECT BY PRIOR rule_id = parent_rule_id
895: START WITH rule_id = Nvl(p_rule_id, -1002)
896: )a WHERE EXISTS
897: (SELECT 'x'
898: FROM cn_attribute_rules car
899: WHERE car.ruleset_id = a.ruleset_id
900: AND car.rule_id = a.rule_id and car.org_id=p_org_id);
901:
902: IF l_count <> 0

Line 1227: FROM cn_attribute_rules cnattr, cn_objects cnobj,

1223: SELECT cnobj.user_name object_name,
1224: cnh.name hierarchy_name, cnattr.column_value column_value,
1225: cnattr.not_flag not_flag, cnattr.high_value high_value,
1226: cnattr.low_value low_value , cnattr.dimension_hierarchy_id dimension_hierarchy_id
1227: FROM cn_attribute_rules cnattr, cn_objects cnobj,
1228: cn_head_hierarchies cnh
1229: WHERE cnattr.rule_id = l_rule_id
1230: AND cnattr.column_id = cnobj.object_id (+)
1231: AND cnattr.org_id = cnobj.org_id

Line 1283: FROM CN_ATTRIBUTE_RULES

1279: -- for user created expressions
1280:
1281: SELECT DISTINCT expression
1282: INTO rule_exp
1283: FROM CN_ATTRIBUTE_RULES
1284: WHERE RULE_ID = p_rule_id ;
1285:
1286: ELSE
1287: -- for expression not 'created' by the user