----------XÓA PL_REQUEST_PROCESS WHERE PROCESS_ID = DVCM------- DELETE FROM PL_REQUEST_PROCESS WHERE REQ_ID = 'TRRD00000255699' AND PROCESS_ID = 'DVCM' --------XÓA LỊCH SỬ ĐIỀU PHỐI PROCESS_ID DVCM--------- DELETE FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID = 'TRRD00000255699' AND PROCESS_ID = 84964 ---------XÓA DVCM TRONG TR_REQUEST_COSTCENTER------ DELETE FROM TR_REQUEST_COSTCENTER WHERE REQ_ID = 'TRRD00000255699' ----------UPDATE TRẠNG THÁI PHIẾU BƯỚC KẾ TIẾP--------------- UPDATE PL_REQUEST_PROCESS SET STATUS = 'C', PARENT_PROCESS_ID = 'DMMS' WHERE REQ_ID = 'TRRD00000255699' AND PROCESS_ID = 'GDK_PYC' --------UPDATE PYCMS BƯỚC TIẾP THEO-------------- UPDATE TR_REQUEST_DOC SET PROCESS_ID = 'GDK_PYC' WHERE REQ_ID = 'TRRD00000255699'