APPS.CN_PROC_BATCHES_PKG dependencies on CN_DIM_HIERARCHIES_ALL

Line 235: FROM cn_dim_hierarchies_all

231: x_dim_hierarchy NUMBER;
232:
233: CURSOR l_dim_hierarchy_csr(l_start_date DATE, l_end_date DATE) IS
234: SELECT dim_hierarchy_id
235: FROM cn_dim_hierarchies_all
236: WHERE header_dim_hierarchy_id = (SELECT rev_class_hierarchy_id
237: FROM cn_repositories_all
238: WHERE org_id = g_org_id)
239: AND org_id = g_org_id