APPS.CN_IMP_HIERARCHY_PVT dependencies on CN_HIERARCHY_EDGES

Line 722: FROM cn_hierarchy_edges

718: AND name = l_hierarchy_node_csr.node_name
719: AND external_id = l_external_id;
720:
721: SELECT 1 INTO l_dummy
722: FROM cn_hierarchy_edges
723: WHERE dim_hierarchy_id = p_dim_hierarchy_id
724: AND value_id = l_value_id and org_id=p_org_id
725: AND ((l_parent_value_id IS NULL AND parent_value_id IS NULL) OR
726: (l_parent_value_id IS NOT NULL AND

Line 833: -- cn_hierarchy_nodes, cn_hierarchy_edges

829: -- API name : Hierarchy_Import
830: -- Type : Private.
831: -- Function : programtransfer data from staging table into
832: -- cn_dimension_vl,cn_head_hierarchies,cn_dim_hierarchies
833: -- cn_hierarchy_nodes, cn_hierarchy_edges
834: -- Pre-reqs : None.
835: -- Parameters :
836: -- IN : p_imp_header_id IN NUMBER,
837: -- OUT : errbuf OUT VARCHAR2 Required