1.2 REVERT TTCT 0012 2021 TTr 0690902 - BO SUNG CAP DUYET TGD.txt
1 |
INSERT INTO PL_REQUEST_PROCESS VALUES ('PLRD00000202233','TGD','C','TGD','DV0001','',NULL,'GDK','N','','',N'Chờ Tổng Giám Đốc phê duyệt tờ trình','0','') |
---|---|
2 |
UPDATE PL_REQUEST_PROCESS SET PARENT_PROCESS_ID ='TGD' WHERE REQ_ID ='PLRD00000202233' AND PROCESS_ID ='APPROVE' |
3 |
UPDATE PL_REQUEST_DOC SET PROCESS_ID ='TGD' WHERE REQ_ID ='PLRD00000202233' |
4 |
DELETE FROM PL_TRADEDETAIL_HIST WHERE REQ_ID ='PLRD00000202233' |
5 |
UPDATE PL_TRADEDETAIL SET AMT_ETM = ISNULL(AMT_ETM,0) - 1345000000 WHERE TRADE_ID ='PLT000000278901' |