APPS.CN_IMP_HIERARCHY_PVT dependencies on CN_HIERARCHY_EDGES

Line 716: FROM cn_hierarchy_edges

712: AND name = l_hierarchy_node_csr.node_name
713: AND external_id = l_external_id;
714:
715: SELECT 1 INTO l_dummy
716: FROM cn_hierarchy_edges
717: WHERE dim_hierarchy_id = p_dim_hierarchy_id
718: AND value_id = l_value_id and org_id=p_org_id
719: AND ((l_parent_value_id IS NULL AND parent_value_id IS NULL) OR
720: (l_parent_value_id IS NOT NULL AND

Line 827: -- cn_hierarchy_nodes, cn_hierarchy_edges

823: -- API name : Hierarchy_Import
824: -- Type : Private.
825: -- Function : programtransfer data from staging table into
826: -- cn_dimension_vl,cn_head_hierarchies,cn_dim_hierarchies
827: -- cn_hierarchy_nodes, cn_hierarchy_edges
828: -- Pre-reqs : None.
829: -- Parameters :
830: -- IN : p_imp_header_id IN NUMBER,
831: -- OUT : errbuf OUT VARCHAR2 Required