DBA Data[Home] [Help]

APPS.CS_ASSIGN_RESOURCE_CON_PKG dependencies on CSI_ITEM_INSTANCES

Line 347: FROM csi_item_instances

343:
344: -- List of Cursors used
345: CURSOR c_inv_comp_id(p_component_id NUMBER) IS
346: SELECT inventory_item_id
347: FROM csi_item_instances
348: WHERE instance_id = p_component_id;
349:
350: CURSOR c_inv_subcomp_id(p_subcomponent_id NUMBER) IS
351: SELECT inventory_item_id

Line 352: FROM csi_item_instances

348: WHERE instance_id = p_component_id;
349:
350: CURSOR c_inv_subcomp_id(p_subcomponent_id NUMBER) IS
351: SELECT inventory_item_id
352: FROM csi_item_instances
353: WHERE instance_id = p_subcomponent_id;
354:
355: BEGIN
356: -- Initialize message list if p_init_msg_list is set to TRUE