ALTER PROCEDURE dbo.TR_BUDGET_CHECK_LIMIT_YEAR_HIST_Byid
@p_GD_ID	varchar(20)  = NULL,
@p_GD_CODE	varchar(20)  = NULL,
@p_BRANCH_ID varchar(20)  = NULL,
@p_DEP_ID	varchar(20)  = NULL,
@p_BUDGET_MONTH varchar(20) = NULL,
@p_BUDGET_YEAR varchar(20) = NULL,
@p_BRANCH_KIND varchar(20) = NULL,
@p_TOP INT = 100
AS
BEGIN -- PAGING
	SET @p_TOP = NULL

	IF(@p_TOP IS NULL OR @p_TOP=0)
	BEGIN  
-- PAGING BEGIN
        SELECT A.BUDGET_YEAR_LIMIT_DETAIL_ID, C.REQ_PAY_ID, C.REQ_PAY_CODE, CM.BRANCH_NAME, DP.DEP_NAME,
        trpb.AMT_EXE AS 'REQ_AMT',
        --C.REQ_AMT, 
         trpb.REASON AS 'REQ_REASON',
        --C.REQ_REASON, 
        C.CREATE_DT AS PAYMENT_CREATE_DT, TL1.TLFullName AS GDV, TL2.TLFullName AS KSV, C.APPROVE_DT_KT
-- SELECT END
        FROM TR_REQ_BUDGET_YEAR_LIMIT_DETAIL A
		--LEFT JOIN TR_REQ_BUDGET_YEAR_LIMIT B ON A.BRANCH_ID = B.BRANCH_ID AND A.DEP_ID = B.DEP_ID AND A.GD_ID = B.GD_ID
		LEFT JOIN TR_REQ_PAYMENT C ON A.REQ_PAY_ID = C.REQ_PAY_ID
    LEFT JOIN TR_REQ_PAY_BUDGET trpb ON trpb.REQ_PAY_ID = C.REQ_PAY_ID AND trpb.BRANCH_KIND = @p_BRANCH_KIND
		LEFT JOIN TL_USER TL1 ON C.MAKER_ID_KT = TL1.TLNANME
		LEFT JOIN TL_USER TL2 ON C.CHECKER_ID_KT = TL2.TLNANME
		LEFT JOIN CM_BRANCH CM ON A.BRANCH_ID = CM.BRANCH_ID
		LEFT JOIN CM_DEPARTMENT DP ON A.DEP_ID = DP.DEP_ID
        WHERE 1=1
			AND A.GD_ID = @p_GD_ID 
			AND A.BRANCH_ID = @p_BRANCH_ID 
			AND A.DEP_ID = @p_DEP_ID
			AND A.RECORD_STATUS = '1'
			AND A.BUDGET_YEAR = @p_BUDGET_YEAR
      AND A.BRANCH_KIND = @p_BRANCH_KIND
		ORDER BY A.CREATE_DT DESC
-- PAGING END
    END;
    ELSE 
	BEGIN
-- PAGING BEGIN
        SELECT TOP(CONVERT(INT, @p_TOP)) A.BUDGET_YEAR_LIMIT_DETAIL_ID, C.REQ_PAY_ID, C.REQ_PAY_CODE, CM.BRANCH_NAME, DP.DEP_NAME,
        trpb.AMT_EXE AS 'REQ_AMT',
       -- C.REQ_AMT,
       trpb.REASON AS 'REQ_REASON',
        --C.REQ_REASON, 
        C.CREATE_DT AS PAYMENT_CREATE_DT, TL1.TLFullName AS GDV, TL2.TLFullName AS KSV, C.APPROVE_DT_KT
-- SELECT END
        FROM TR_REQ_BUDGET_YEAR_LIMIT_DETAIL A
		--LEFT JOIN TR_REQ_BUDGET_YEAR_LIMIT B ON A.BRANCH_ID = B.BRANCH_ID AND A.DEP_ID = B.DEP_ID AND A.GD_ID = B.GD_ID
		LEFT JOIN TR_REQ_PAYMENT C ON A.REQ_PAY_ID = C.REQ_PAY_ID
    LEFT JOIN TR_REQ_PAY_BUDGET trpb ON trpb.REQ_PAY_ID = C.REQ_PAY_ID AND trpb.BRANCH_KIND = @p_BRANCH_KIND
		LEFT JOIN TL_USER TL1 ON C.MAKER_ID_KT = TL1.TLNANME
		LEFT JOIN TL_USER TL2 ON C.CHECKER_ID_KT = TL2.TLNANME
		LEFT JOIN CM_BRANCH CM ON A.BRANCH_ID = CM.BRANCH_ID
		LEFT JOIN CM_DEPARTMENT DP ON A.DEP_ID = DP.DEP_ID
        WHERE 1=1
			AND A.GD_ID = @p_GD_ID 
			AND A.BRANCH_ID = @p_BRANCH_ID 
			AND A.DEP_ID = @p_DEP_ID
			AND A.RECORD_STATUS = '1'
			AND A.BUDGET_YEAR = @p_BUDGET_YEAR
      AND A.BRANCH_KIND = @p_BRANCH_KIND
		ORDER BY A.CREATE_DT DESC
-- PAGING END
    END;
END -- PAGING