DECLARE @REQ_ID VARCHAR(15), @PROCESS_ID VARCHAR(15)
SET @REQ_ID =(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0138/2023/TTr-0690604')
SET @PROCESS_ID =(SELECT PROCESS_ID FROM PL_REQUEST_DOC WHERE REQ_ID =@REQ_ID)
INSERT INTO PL_REQUEST_PROCESS VALUES (@REQ_ID,'TKHDQT','C','TKHDQT','','',NULL,'TGD','N','','',N'Chờ Văn Phòng Chủ Tịch HĐQT xác nhận','1','','')
INSERT INTO PL_REQUEST_PROCESS VALUES (@REQ_ID,'HDQT','U','HDQT','','',NULL,'TKHDQT','N','','',N'Chờ Chủ Tịch HĐQT phê duyệt','0','','')
UPDATE PL_REQUEST_DOC SET PROCESS_ID ='TKHDQT' WHERE REQ_ID =@REQ_ID
UPDATE PL_REQUEST_PROCESS SET PARENT_PROCESS_ID ='HDQT', STATUS ='U' WHERE REQ_ID =@REQ_ID AND PROCESS_ID =@PROCESS_ID