DECLARE @REQ_PAY_ID VARCHAR(20)
SET @REQ_PAY_ID = (SELECT REQ_PAY_ID FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_CODE = 'NBO.2022.000387')

SELECT * FROM TR_REQ_ADVANCE_PAYMENT WHERE REQ_PAY_CODE = 'NBO.2022.000387'

SELECT * FROM PL_REQUEST_PROCESS WHERE REQ_ID = @REQ_PAY_ID

SELECT * FROM PL_PROCESS WHERE REQ_ID = @REQ_PAY_ID

/*
UPDATE TR_REQ_ADVANCE_PAYMENT SET PROCESS = '0' WHERE REQ_PAY_CODE = 'NBO.2022.000387'
UPDATE PL_REQUEST_PROCESS SET PROCESS_iID = '0' WHERE 1=2
UPDATE PL_REQUEST_PROCESS SET PROCESS_ID = '0' WHERE 1=2
*/