APPS.CN_REVENUE_CLASS_PVT dependencies on CN_DIM_HIERARCHIES

Line 527: FROM cn_hierarchy_nodes chn , cn_dim_hierarchies cdh

523: --
524:
525: SELECT nvl(MAX(ref_count),0)
526: INTO l_hierarchy_count
527: FROM cn_hierarchy_nodes chn , cn_dim_hierarchies cdh
528: WHERE chn.external_id = p_revenue_Class_id
529: AND chn.dim_hierarchy_id = cdh.dim_hierarchy_id
530: AND cdh.header_dim_hierarchy_id = -1001;
531:

Line 538: FROM cn_dim_hierarchies

534: -- Delete this revenue class from nodes table.
535: DELETE FROM cn_hierarchy_nodes
536: WHERE external_id = p_revenue_Class_id
537: AND dim_hierarchy_id IN (SELECT dim_hierarchy_id
538: FROM cn_dim_hierarchies
539: WHERE header_dim_hierarchy_id = -1001);
540: END IF;
541:
542: l_total_count := l_rule_count + l_hierarchy_count + l_quota_rule_count;