DECLARE @REQ_ID VARCHAR(15)
SET @REQ_ID=(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0042/2021/TTr-0690405')
INSERT INTO PL_REQUEST_PROCESS VALUES (@REQ_ID,'TGD','P','TGD','DV0001','trungnq1','5/18/2021 10:30:53 AM','PTGDK_TT','N','','',N'Tổng giám đốc đã phê duyệt','0','')
INSERT INTO PL_PROCESS VALUES (@REQ_ID,'TGD','trungnq1','5/18/2021 10:30:53 AM',N'Phê duyệt',N'Tổng giám đốc đã phê duyệt')
UPDATE PL_REQUEST_PROCESS SET PARENT_PROCESS_ID ='TGD' WHERE REQ_ID =@REQ_ID AND PROCESS_ID ='APPROVE'