DECLARE @REQ_ID VARCHAR(15)
SET @REQ_ID = (SELECT REQ_PAY_ID FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_CODE ='NBO.2021.000119')
EXEC TR_REQ_ADVANCE_PAYMENT_Appr @REQ_ID,'trungnq1','A',''

SET @REQ_ID = (SELECT REQ_PAY_ID FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_CODE ='NBO.2021.000123')
EXEC TR_REQ_ADVANCE_PAYMENT_Appr @REQ_ID,'trungnq1','A',''