APPS.CN_HEAD_HIERARCHIES_ALL_PKG dependencies on CN_DIM_HIERARCHIES

Line 151: from cn_dim_hierarchies

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
154: AND org_id = X_ORG_ID);
155: --R12 MOAC Changes--End

Line 158: from cn_dim_hierarchies

154: AND org_id = X_ORG_ID);
155: --R12 MOAC Changes--End
156: delete from cn_hierarchy_edges e where dim_hierarchy_id in
157: (select dim_hierarchy_id
158: from cn_dim_hierarchies
159: where header_dim_hierarchy_id = X_HEAD_HIERARCHY_ID
160: --R12 MOAC Changes--Start
161: AND org_id = X_ORG_ID);
162: --R12 MOAC Changes--End

Line 163: delete from cn_dim_hierarchies d

159: where header_dim_hierarchy_id = X_HEAD_HIERARCHY_ID
160: --R12 MOAC Changes--Start
161: AND org_id = X_ORG_ID);
162: --R12 MOAC Changes--End
163: delete from cn_dim_hierarchies d
164: where header_dim_hierarchy_id = X_HEAD_HIERARCHY_ID
165: --R12 MOAC Changes--Start
166: AND org_id = X_ORG_ID;
167: --R12 MOAC Changes--End