|
1
|
SELECT * FROM MW_ENTRIES_POST WHERE TRN_ID ='MWTF00000250181' AND DR_ACCT IS NULL
|
|
2
|
DECLARE @REQ_ID VARCHAR(15)
|
|
3
|
SET @REQ_ID=(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0009/2021/TTr-0690902')
|
|
4
|
EXEC dbo.PL_REQUEST_PROCESS_App @p_REQ_ID = @REQ_ID, -- varchar(15)
|
|
5
|
@p_AUTH_STATUS = 'A', -- varchar(1)
|
|
6
|
@p_CHECKER_ID = 'trungnq1', -- varchar(15)
|
|
7
|
@p_APPROVE_DT = '2021-07-20 12:00:00 AM', -- datetime
|
|
8
|
@p_ROLE_LOGIN = 'TGD', -- varchar(50)
|
|
9
|
@p_BRANCH_LOGIN = 'DV0001', -- varchar(15)
|
|
10
|
@p_PROCESS_DESC = N'Phê duyệt' -- nvarchar(max)
|
|
11
|
|
|
12
|
|
|
13
|
SET @REQ_ID=(SELECT REQ_ID FROM PL_REQUEST_DOC WHERE REQ_CODE ='0010/2021/TTr-0690902')
|
|
14
|
EXEC dbo.PL_REQUEST_PROCESS_App @p_REQ_ID = @REQ_ID, -- varchar(15)
|
|
15
|
@p_AUTH_STATUS = 'A', -- varchar(1)
|
|
16
|
@p_CHECKER_ID = 'trungnq1', -- varchar(15)
|
|
17
|
@p_APPROVE_DT = '2021-07-20 12:00:00 AM', -- datetime
|
|
18
|
@p_ROLE_LOGIN = 'TGD', -- varchar(50)
|
|
19
|
@p_BRANCH_LOGIN = 'DV0001', -- varchar(15)
|
|
20
|
@p_PROCESS_DESC = N'Phê duyệt' -- nvarchar(max)
|
|
21
|
|
|
22
|
EXEC dbo.PL_REQUEST_PROCESS_App @p_REQ_ID = @REQ_ID, -- varchar(15)
|
|
23
|
@p_AUTH_STATUS = 'A', -- varchar(1)
|
|
24
|
@p_CHECKER_ID = 'taila', -- varchar(15)
|
|
25
|
@p_APPROVE_DT = '2021-07-20 12:00:00 AM', -- datetime
|
|
26
|
@p_ROLE_LOGIN = 'HDQT', -- varchar(50)
|
|
27
|
@p_BRANCH_LOGIN = 'DV0001', -- varchar(15)
|
|
28
|
@p_PROCESS_DESC = N'Phê duyệt' -- nvarchar(max)
|
|
29
|
|
|
30
|
|
|
31
|
--2021720
|