APPS.CN_RULES_DISP_PUB dependencies on CN_HIERARCHY_NODES

Line 192: FROM cn_hierarchy_nodes

188:
189: IF expr.dimension_hierarchy_id IS NOT NULL THEN
190: l_column_value := expr.column_value;
191: SELECT name INTO node_value
192: FROM cn_hierarchy_nodes
193: WHERE value_id=l_column_value;
194:
195: IF expr.not_flag = 'N' THEN
196: x_rules_display_tbl(x_rules_count).rule_expression := x_rules_display_tbl(x_rules_count).rule_expression || expr.object_name || l_desc || '''' || node_value || '''' || l_hier || '''' || expr.hierarchy_name || '''' || ' ' ;

Line 270: FROM cn_hierarchy_nodes

266:
267: IF expr.dimension_hierarchy_id IS NOT NULL THEN
268: l_column_value := expr.column_value;
269: SELECT name INTO node_value
270: FROM cn_hierarchy_nodes
271: WHERE value_id=l_column_value;
272:
273: IF expr.not_flag = 'N' THEN
274: x_rules_display_tbl(x_rules_count).rule_expression := x_rules_display_tbl(x_rules_count).rule_expression || expr.object_name || l_desc || '''' || node_value || '''' || l_hier || '''' || expr.hierarchy_name || '''' || ' ' ;