APPS.CS_SR_TASK_AUTOASSIGN_PKG dependencies on CSI_ITEM_INSTANCES

Line 183: FROM csi_item_instances

179:
180: -- Added the following cursors for ER# 3811871.
181: CURSOR c_inv_comp_id(p_component_id NUMBER) IS
182: SELECT inventory_item_id
183: FROM csi_item_instances
184: WHERE instance_id = p_component_id;
185:
186: CURSOR c_inv_subcomp_id(p_subcomponent_id NUMBER) IS
187: SELECT inventory_item_id

Line 188: FROM csi_item_instances

184: WHERE instance_id = p_component_id;
185:
186: CURSOR c_inv_subcomp_id(p_subcomponent_id NUMBER) IS
187: SELECT inventory_item_id
188: FROM csi_item_instances
189: WHERE instance_id = p_subcomponent_id;
190:
191: -- Added cursor to fetch the number of Employees for a
192: -- customer, for ER# 4107660.