APPS.EAM_WO_NETWORK_UTIL_PVT dependencies on WIP_OPERATION_RESOURCES

Line 188: FROM WIP_OPERATION_RESOURCES WOR

184: CURSOR workorder_resources_cur (l_obj_id NUMBER, l_obj_type_id NUMBER) IS
185: select WOR.START_DATE, WOR.COMPLETION_DATE,
186: WOR.OPERATION_SEQ_NUM,
187: WOR.RESOURCE_SEQ_NUM
188: FROM WIP_OPERATION_RESOURCES WOR
189: WHERE WOR.WIP_ENTITY_ID = l_obj_id
190: AND l_obj_type_id = 1;
191:
192: CURSOR workorder_res_inst_cur (l_obj_id NUMBER, l_obj_type_id NUMBER) IS

Line 694: UPDATE WIP_OPERATION_RESOURCES WOR

690: WHERE WO.WIP_ENTITY_ID = l_work_object_id
691: AND l_work_object_type_id = 1;
692:
693:
694: UPDATE WIP_OPERATION_RESOURCES WOR
695: SET WOR.START_DATE = WOR.START_DATE + l_offset_days,
696: WOR.COMPLETION_DATE = WOR.COMPLETION_DATE + l_offset_days
697: WHERE WOR.WIP_ENTITY_ID = l_work_object_id
698: AND l_work_object_type_id = 1;