-----------UPDATE TR_REQUEST_DOC-----------------
UPDATE TR_REQUEST_DOC SET DMMS_ID = (SELECT TOP 1 DMMS_ID FROM CM_DMMS WHERE BRANCH_ID = 'BRN000000000833') 
WHERE REQ_ID = 'TRRD00000257401'

-----------UPDATE PL_REQUEST_PROCESS-------------
UPDATE PL_REQUEST_PROCESS SET DVDM_ID = (SELECT TOP 1 DMMS_ID FROM CM_DMMS WHERE BRANCH_ID = 'BRN000000000833')
WHERE REQ_ID = 'TRRD00000257401' AND PROCESS_ID = 'DMMS'

----------XÓA PL_REQUEST_PROCESS_CHILD-----------
DELETE FROM PL_REQUEST_PROCESS_CHILD WHERE REQ_ID = 'TRRD00000257401' AND PROCESS_ID = (SELECT TOP 1 ID FROM PL_REQUEST_PROCESS WHERE REQ_ID = 'TRRD00000257401' AND PROCESS_ID = 'DMMS')

--------------INSERT XỬ LÝ-------------------------
INSERT INTO dbo.PL_PROCESS
		(
			REQ_ID,
			PROCESS_ID,
			CHECKER_ID,
			APPROVE_DT,
			PROCESS_DESC,NOTES
		)
		VALUES
		(   'TRRD00000257401',        -- REQ_ID - varchar(15)
			'IT',        -- PROCESS_ID - varchar(10)
			'',        -- CHECKER_ID - varchar(15)
			GETDATE() , -- APPROVE_DT - datetime
			--@p_PROCESS_DES,
			N'Phòng Hành Chính chuyển phiếu về DVKD tự mua',
			 N'Phòng Hành Chính chuyển phiếu về DVKD tự mua'        -- PROCESS_DESC - nvarchar(1000)
		)