APPS.CN_REVENUE_CLASS_PVT dependencies on CN_HIERARCHY_NODES

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 535: DELETE FROM cn_hierarchy_nodes

531:
532: IF (l_hierarchy_count = 0) THEN
533:
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);