DBA Data[Home] [Help]

APPS.CSP_REP_HIERARCHIES_PKG dependencies on CSP_SEC_INVENTORIES

Line 203: Update csp_sec_inventories

199:
200: BEGIN
201:
202: -- Update Subinventory for the Hierarchy node
203: Update csp_sec_inventories
204: set hierarchy_node_id = NULL
205: where hierarchy_node_id = p_HIERARCHY_NODE_ID;
206:
207: -- Update Subinventory for all the SubHierarchy nodes

Line 208: Update csp_sec_inventories

204: set hierarchy_node_id = NULL
205: where hierarchy_node_id = p_HIERARCHY_NODE_ID;
206:
207: -- Update Subinventory for all the SubHierarchy nodes
208: Update csp_sec_inventories
209: set hierarchy_node_id = NULL
210: where hierarchy_node_id in (select rh.hierarchy_node_id
211: from csp_rep_hierarchies rh
212: where parent_node_id = p_HIERARCHY_NODE_ID);