UPDATE PL_REQUEST_PROCESS SET DEP_ID ='DEP000000000807' WHERE DEP_ID ='DEP000000000733' AND STATUS ='C' SELECT * FROM PL_COSTCENTER_DT WHERE DEP_ID ='DEP000000000733' SELECT * FROM PL_COSTCENTER_DT WHERE DEP_ID ='DEP000000000807'