Project

General

Profile

FILE 1- UPDATE PL.txt

Truong Nguyen Vu, 09/10/2020 11:28 AM

 
1
DELETE FROM dbo.PL_REQUEST_PROCESS WHERE ID='1736'
2
UPDATE dbo.PL_REQUEST_PROCESS SET PARENT_PROCESS_ID='GDK_DC',STATUS='C' WHERE ID='1540'
3

    
4
UPDATE dbo.PL_REQUEST_DOC SET PROCESS_ID='APPROVE' WHERE REQ_ID='PLRD00000200134'
5
EXEC dbo.PL_REQ_DOC_UPDATE_AFTER_APPROVE @p_REQ_ID = 'PLRD00000200134' 
6
EXEC dbo.PL_REQ_DOC_Ins_To_TR_REQ_DOC @p_PL_REQ_ID = 'PLRD00000200134'