DBA Data[Home] [Help]

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