APPS.CN_CALC_POPULATE_PVT dependencies on CN_DIM_EXPLOSION_ALL

Line 314: and exists (select /*+ no_unnest */ 1 from cn_dim_explosion_all de

310: and dh.header_dim_hierarchy_id = l_rev_class_hierarchy_id
311: and dh.org_id = g_org_id
312: and dh.start_date <= least(nvl(spa.end_date, p_end_date), nvl(q.end_date, p_end_date))
313: and nvl(dh.end_date, p_end_date) >= greatest(spa.start_date, q.start_date)
314: and exists (select /*+ no_unnest */ 1 from cn_dim_explosion_all de
315: where de.dim_hierarchy_id = dh.dim_hierarchy_id
316: and de.ancestor_external_id = qr.revenue_class_id
317: and de.value_external_id = p_revenue_class_id)
318: order by greatest(dh.start_date, spa.start_date, q.start_date, rr.start_date_active, p_start_date),

Line 431: cn_dim_explosion_all de

427:
428: CURSOR l_quota_rule_hier_csr (l_quota_id NUMBER, l_revenue_class_id NUMBER ) IS
429: SELECT qr.quota_rule_id
430: FROM cn_quota_rules_all qr,
431: cn_dim_explosion_all de
432: WHERE qr.quota_id = l_quota_id
433: AND de.dim_hierarchy_id = l_dim_hierarchy_id
434: AND de.value_external_id = l_revenue_class_id
435: AND de.ancestor_external_id = qr.revenue_class_id;