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

DECLARE @GDV NVARCHAR(50), @KSV NVARCHAR(50)

IF(LEFT(@p_REF_ID, 4) = 'TADY')
BEGIN
	SET @GDV = (SELECT TOP 1 UPPER(TU.TLFullName)
				FROM TL_USER TU
				LEFT JOIN TR_REQ_ADVANCE_PAYMENT TRP ON TU.TLNANME = TRP.MAKER_ID_KT
				WHERE TRP.REQ_PAY_ID = @p_REF_ID)

	SET @KSV = (SELECT TOP 1 UPPER(TU.TLFullName)
				FROM TL_USER TU
				LEFT JOIN TR_REQ_ADVANCE_PAYMENT TRP ON TU.TLNANME = TRP.CHECKER_ID_KT
				WHERE TRP.REQ_PAY_ID = @p_REF_ID)

	SELECT REQ_TRANS_OUTSIDE_REC_ID,REQ_PAY_ID AS 'TRN_ID', REF_NO, 
			ISNULL(FORMAT(TRANSFER_DT,'dd/MM/yyyy'),'') AS 'PrintDate', 
			dbo.fChuyenCoDauThanhKhongDau(@GDV) AS 'G_D_V', dbo.fChuyenCoDauThanhKhongDau(@KSV) AS 'K_S_V'
	FROM TR_REQ_PAY_TRANS_OUTSIDE_REC
	WHERE REQ_PAY_ID = @p_REF_ID
END
ELSE
BEGIN
	SET @GDV = (SELECT TOP 1 UPPER(TU.TLFullName)
				FROM TL_USER TU
				LEFT JOIN TR_REQ_PAYMENT TRP ON TU.TLNANME = TRP.MAKER_ID_KT
				WHERE TRP.REQ_PAY_ID = @p_REF_ID)

	SET @KSV = (SELECT TOP 1 UPPER(TU.TLFullName)
				FROM TL_USER TU
				LEFT JOIN TR_REQ_PAYMENT TRP ON TU.TLNANME = TRP.CHECKER_ID_KT
				WHERE TRP.REQ_PAY_ID = @p_REF_ID)

	SELECT REQ_TRANS_OUTSIDE_REC_ID,REQ_PAY_ID AS 'TRN_ID', REF_NO, 
			ISNULL(FORMAT(TRANSFER_DT,'dd/MM/yyyy'),'') AS 'PrintDate', 
			dbo.fChuyenCoDauThanhKhongDau(@GDV) AS 'G_D_V', dbo.fChuyenCoDauThanhKhongDau(@KSV) AS 'K_S_V'
	FROM TR_REQ_PAY_TRANS_OUTSIDE_REC
	WHERE REQ_PAY_ID = @p_REF_ID
END