CREATE PROCEDURE [dbo].[PAY_TRANSFER_OUTSIDE_REC_ByRefId] 
@p_REF_ID VARCHAR(200) = NULL, 
@p_BRANCH_ID VARCHAR(50) = NULL, 
@p_RefNo VARCHAR(500) = NULL
AS

SELECT POR.REQ_TRANS_OUTSIDE_REC_ID,TOT.BRANCH_TRANFSER_NAME, TOT.ACC_NO_TRANSFER, REF_NO, 
	dbo.fChuyenCoDauThanhKhongDau((SELECT TOP 1 BRANCH_NAME FROM CM_BRANCH WHERE BRANCH_ID = TOT.brancH_ID)) AS 'BRANCH_NAME', 
	POR.BRANCH_RECEIVE_NAME, POR.ACC_NO_RECEIVE AS 'ACCT_NO', POR.BANK_RECEIVE_ID AS 'BANK_RECEIVE_NAME', 
	REPLACE (FORMAT (POR.TRADE_AMT,'#,###'),',','.') +',00 VND' AS TRADE_AMT,
	REPLACE(dbo.ReadMoney(POR.TRADE_AMT),'  ',' ') AS 'STRING_MONEY', POR.TRADE_DESC
FROM TR_REQ_PAY_TRANS_OUTSIDE_REC POR
LEFT JOIN TR_REQ_PAY_TRANS_OUTSIDE_TRANS TOT ON POR.REQ_PAY_ID = TOT.REQ_PAY_ID
WHERE POR.REQ_PAY_ID = @p_REF_ID