2.6 BO SUNG THU KY TGD - THU KY HDQT.txt
| 1 |
DELETE FROM PL_REQUEST_PROCESS WHERE ID ='76082' |
|---|---|
| 2 |
UPDATE PL_REQUEST_DOC SET PROCESS_ID ='TKTGD' WHERE REQ_ID ='PLRD00000205578' |
| 3 |
INSERT INTO PL_REQUEST_PROCESS VALUES ('PLRD00000205578','TKTGD','C','TKTGD','','',NULL,'PTGDK_TT','N','','',N'Chờ Thư Ký TGĐ xác nhận','1','','')
|
| 4 |
UPDATE PL_REQUEST_PROCESS SET PARENT_PROCESS_ID ='TKTGD', STATUS ='U' WHERE REQ_ID ='PLRD00000205578' AND PROCESS_ID ='TGD' |
| 5 |
INSERT INTO PL_REQUEST_PROCESS VALUES ('PLRD00000205578','TKHDQT','U','TKHDQT','','',NULL,'TGD','N','','',N'Chờ Thư Ký HĐQT xác nhận','1','','')
|
| 6 |
UPDATE PL_REQUEST_PROCESS SET PARENT_PROCESS_ID ='TKHDQT' WHERE REQ_ID ='PLRD00000205578' AND PROCESS_ID ='HDQT' |
| 7 |
|
| 8 |
EXEC PL_PROCESS_CURRENT_SEARCH 'PLRD00000205578','phuongnht','TTCT' |