Project

General

Profile

Support #659

Cập nhật Hoàn Tất các tờ trình chủ trương đã được duyệt giấy

Added by Luc Tran Van over 4 years ago. Updated over 4 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Luc Tran Van
Start date:
11/23/2020
Due date:
% Done:

0%

Estimated time:

Description

DECLARE @REQ_ID VARCHAR
SET @REQ_ID =(SELECT TOP 1 REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE='0010/2020/TTr-0691006')
UPDATE PL_REQUEST_DOC SET AUTH_STATUS ='A', PROCESS_ID ='APPROVE', REQ_CODE ='25/2019/TTr-NHĐT',REQ_DT ='2019-12-03',CREATE_DT = REQ_DT, EFFEC_DT = REQ_DT WHERE REQ_ID =@REQ_ID

SET @REQ_ID =(SELECT TOP 1 REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE='0011/2020/TTr-0691006')
UPDATE PL_REQUEST_DOC SET AUTH_STATUS ='A', PROCESS_ID ='APPROVE', REQ_CODE ='87B/2020/TTr-SP&MKT',REQ_DT ='2020-04-22',CREATE_DT = REQ_DT, EFFEC_DT = REQ_DT WHERE REQ_ID =@REQ_ID

SET @REQ_ID =(SELECT TOP 1 REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE='0008/2020/TTr-0692205')
UPDATE PL_REQUEST_DOC SET AUTH_STATUS ='A', PROCESS_ID ='APPROVE', REQ_CODE ='35/2020/TTr-K.KHDN',REQ_DT ='2020-03-13',CREATE_DT = REQ_DT, EFFEC_DT = REQ_DT WHERE REQ_ID =@REQ_ID

History

#1 Updated by Luc Tran Van over 4 years ago

  • Status changed from New to Closed

Also available in: Atom PDF