ALTER   PROC [dbo].[TR_REQ_PAY_BUDGET_ByID]
@p_REQ_PAY_ID VARCHAR(1500) = NULL
AS
BEGIN
-- NHIEU PO HOAC SO PHIEU TAM UNG / THANH TOAN
		DECLARE @l_LSTSERI TABLE (
		[ID] [int] IDENTITY(1,1) NOT NULL,
		[VALUE] [NVARCHAR](MAX) NULL)
		DECLARE @l_FILENAME VARCHAR(MAX)
		INSERT INTO @l_LSTSERI SELECT VALUE FROM WSISPLIT(@p_REQ_PAY_ID,';')
	----
	DECLARE @t_NSCP_ACCNO TABLE(
	GD_CODE VARCHAR(250),
	ACC_NO VARCHAR(20), 
	COST_APPR DECIMAL(18, 0)
	)
	insert into @t_NSCP_ACCNO  SELECT GD_CODE, ACC_NO, COUNT(GD_CODE)  FROM TR_REQ_BUGGED_NSCP GROUP BY GD_CODE, ACC_NO

	SELECT A.*,B.GOODS_CODE,G.GD_ID AS GOODS_ID,G.GD_NAME AS GOODS_NAME,A.RATE,  A.CURRENCY,
	 0.0 AMT_REMAIN_HIS, NSCP.ACC_NO,
	CASE WHEN ISNULL(A.TLNAME, '') <> '' THEN H.TLNANME + ' - ' + H.TLFullName
	ELSE I.BRANCH_CODE + ' - ' + I.BRANCH_NAME
	END AS DISPLAY_NAME
	FROM TR_REQ_PAY_BUDGET A
	LEFT JOIN PL_TRADEDETAIL B ON A.TRADE_ID = B.TRADE_ID
	LEFT JOIN CM_GOODS G ON B.GOODS_ID = G.GD_ID
	LEFT JOIN @t_NSCP_ACCNO NSCP ON  G.GD_CODE = NSCP.GD_CODE
	LEFT JOIN TL_USER H ON  A.TLNAME = H.TLNANME
	LEFT JOIN CM_BRANCH I ON  A.BRANCH_TAKE_COST_ID = I.BRANCH_ID
	WHERE A.REQ_PAY_ID IN (SELECT VALUE FROM @l_LSTSERI)
END