APPS.CN_DIMENSIONS_PKG dependencies on CN_HIERARCHY_NODES
Line 192: delete from cn_hierarchy_nodes e where dim_hierarchy_id in
188: and org_id = X_ORG_ID;
189: --R12 MOAC Changes--End
190:
191: -- remove dangling head hierarchies, dim hierarchies and tree fragments 192: delete from cn_hierarchy_nodes e where dim_hierarchy_id in 193: (select d.dim_hierarchy_id
194: from cn_dim_hierarchies d, cn_head_hierarchies h
195: where h.dimension_id = X_DIMENSION_ID
196: --R12 MOAC Changes--Start