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