APPS.EAM_WO_NETWORK_UTIL_PVT dependencies on WIP_OP_RESOURCE_INSTANCES

Line 198: FROM WIP_OP_RESOURCE_INSTANCES WORI

194: wORI.OPERATION_SEQ_NUM,
195: WORI.RESOURCE_SEQ_NUM,
196: WORI.INSTANCE_ID,
197: WORI.SERIAL_NUMBER
198: FROM WIP_OP_RESOURCE_INSTANCES WORI
199: WHERE WORI.WIP_ENTITY_ID = l_obj_id
200: AND l_obj_type_id = 1;
201:
202: CURSOR workorder_res_usage_cur (l_obj_id NUMBER, l_obj_type_id NUMBER) IS

Line 708: UPDATE WIP_OP_RESOURCE_INSTANCES WORI

704: WHERE WORU.WIP_ENTITY_ID = l_work_object_id
705: AND l_work_object_type_id = 1;
706:
707:
708: UPDATE WIP_OP_RESOURCE_INSTANCES WORI
709: SET WORI.START_DATE = WORI.START_DATE + l_offset_days,
710: WORI.COMPLETION_DATE = WORI.COMPLETION_DATE + l_offset_days
711: WHERE WORI.WIP_ENTITY_ID = l_work_object_id
712: AND l_work_object_type_id = 1;