APPS.CS_ASSIGN_RESOURCE_PKG dependencies on CSI_ITEM_INSTANCES

Line 185: FROM csi_item_instances

181:
182: -- List of Cursors used
183: CURSOR c_inv_comp_id(p_component_id NUMBER) IS
184: SELECT inventory_item_id
185: FROM csi_item_instances
186: WHERE instance_id = p_component_id;
187:
188: CURSOR c_inv_subcomp_id(p_subcomponent_id NUMBER) IS
189: SELECT inventory_item_id

Line 190: FROM csi_item_instances

186: WHERE instance_id = p_component_id;
187:
188: CURSOR c_inv_subcomp_id(p_subcomponent_id NUMBER) IS
189: SELECT inventory_item_id
190: FROM csi_item_instances
191: WHERE instance_id = p_subcomponent_id;
192:
193: BEGIN
194:

Line 680: from csi_item_instances

676: If l_system_id is Null then
677:
678: Begin
679: Select system_id into l_system_id
680: from csi_item_instances
681: Where instance_id = l_customer_product_id;
682: Exception
683: When Others Then
684: l_system_id := Null ;

Line 1109: from csi_item_instances

1105: If l_system_id is Null then
1106:
1107: Begin
1108: Select system_id into l_system_id
1109: from csi_item_instances
1110: Where instance_id = l_customer_product_id;
1111: Exception
1112: When Others Then
1113: l_system_id := Null ;