Project

General

Profile

Document #880

CAP NHAT LUI NGAY PUR

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

Status:
Closed
Priority:
Normal
Assignee:
Luc Tran Van
Start date:
02/03/2021
Due date:
% Done:

0%

Estimated time:

Description

DECLARE @REQ_ID VARCHAR
SET @REQ_ID= (SELECT TOP 1 REQ_ID FROM TR_REQUEST_DOC WHERE REQ_CODE ='PUR/2021/000071')
UPDATE PL_REQUEST_PROCESS SET APPROVE_DT='2021-01-08' WHERE REQ_ID =@REQ_ID AND PROCESS_ID <>'APPROVE'
UPDATE PL_PROCESS SET APPROVE_DT ='2021-01-08' WHERE REQ_ID =@REQ_ID
UPDATE TR_REQUEST_DOC SET APPROVE_DT ='2021-01-08' WHERE REQ_ID =@REQ_ID

History

#1 Updated by Luc Tran Van over 4 years ago

  • Status changed from New to Closed
  • Assignee set to Luc Tran Van

Also available in: Atom PDF