APPS.CN_HEAD_HIERARCHIES_ALL_PKG dependencies on CN_HIERARCHY_NODES

Line 149: delete from cn_hierarchy_nodes e where dim_hierarchy_id in

145: select X_ORG_ID
146: into l_env_org_id from dual;
147:
148: -- remove dangling dim hierarchies and tree fragments
149: delete from cn_hierarchy_nodes e where dim_hierarchy_id in
150: (select dim_hierarchy_id
151: from cn_dim_hierarchies
152: where header_dim_hierarchy_id = X_HEAD_HIERARCHY_ID
153: --R12 MOAC Changes--Start