1.0 REVERT TTCT VE VP HDQT.txt
| 1 |
DECLARE @REQ_ID VARCHAR(15), @PROCESS_ID VARCHAR(15) |
|---|---|
| 2 |
SET @REQ_ID =(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0138/2023/TTr-0690604') |
| 3 |
SET @PROCESS_ID =(SELECT PROCESS_ID FROM PL_REQUEST_DOC WHERE REQ_ID =@REQ_ID) |
| 4 |
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','','') |
| 5 |
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','','') |
| 6 |
UPDATE PL_REQUEST_DOC SET PROCESS_ID ='TKHDQT' WHERE REQ_ID =@REQ_ID |
| 7 |
UPDATE PL_REQUEST_PROCESS SET PARENT_PROCESS_ID ='HDQT', STATUS ='U' WHERE REQ_ID =@REQ_ID AND PROCESS_ID =@PROCESS_ID |