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