UPDATE wbs
SET wbs_status_id = 1,lm_date = SYSDATE, lm_name = 'PSI'
WHERE wbs_id IN (SELECT wbs_id FROM wbs
WHERE poi_id IN (SELECT poi_id FROM oc_poi op, oc_poi_category opc
WHERE op.oc_poi_category_id = opc.oc_poi_category_id
AND op.oc_poi_status_id = 1
AND opc.operation_center_id = 102017));