DECLARE @GODD_ID VARCHAR(20) = '', @TRADE_ID VARCHAR(20) = '', @REQ_PAY_ID VARCHAR(20) = ''
SET @GODD_ID = (SELECT TOP 1 GD_ID FROM CM_GOODS WHERE GD_CODE = 'HR.I.N.OE.0068.2023')
SET @REQ_PAY_ID = (SELECT TOP 1 REQ_PAY_ID from TR_REQ_PAYMENT where REQ_PAY_CODE = '042023/000360')
SET @TRADE_ID = ( SELECT TOP 1 TRADE_ID FROM TR_REQ_PAY_BUDGET WHERE REQ_PAY_ID = @REQ_PAY_ID)

select REQ_PAY_CODE, AUTH_STATUS, AUTH_STATUS_KT from TR_REQ_PAYMENT where REQ_PAY_CODE = '042023/000360'
select TRADE_ID, GOODS_ID, AMT_APP, AMT_ETM, AMT_EXE from PL_TRADEDETAIL where TRADE_ID = @TRADE_ID AND GOODS_ID = @GODD_ID
SELECT * FROM TR_REQ_PAY_BUDGET WHERE REQ_PAY_ID = @REQ_PAY_ID
--update 26042023_secretkey