ALTER PROCEDURE [dbo].[TR_REQ_Job_Log]
@p_REQ_ID	varchar(15)= NULL,
@p_TOP INT = 10,
@p_LEVEL varchar(10) = NULL,
@p_BRANCH_LOGIN VARCHAR(15) = NULL,
@p_PAY_TYPE VARCHAR(15) = NULL
AS
BEGIN -- PAGING
SET @p_TOP = NULL
		declare @tmp table(BRANCH_ID varchar(15))
		insert into @tmp  SELECT BRANCH_ID  FROM [dbo].[CM_BRANCH_GETCHILDID](@p_BRANCH_LOGIN)

	IF(@P_TOP IS NULL OR @P_TOP = '' OR @P_TOP = 0 OR @P_TOP>0)
	BEGIN
-- PAGING BEGIN
        SELECT A.REQ_PAY_ID, TR.REQ_PAY_CODE, CMB.BRANCH_NAME, CMD.DEP_NAME, A.PAY_AMT, A.PAY_PHASE, A.PAY_DESC, A.PAY_TYPE, AL.CONTENT AS PAY_TYPE_NAME,
		TR.CREATE_DT, TL1.TLFullName AS GDV, TL2.TLFullName AS KSV, TR.APPROVE_DT_KT
-- SELECT END
        FROM TR_REQ_PAY_JOB A
		LEFT JOIN TR_REQ_PAYMENT TR ON A.REQ_PAY_ID = TR.REQ_PAY_ID
		LEFT JOIN CM_BRANCH CMB ON TR.BRANCH_ID = CMB.BRANCH_ID
		LEFT JOIN CM_DEPARTMENT CMD ON TR.DEP_ID = CMD.DEP_ID
		LEFT JOIN TL_USER TL1 ON TR.MAKER_ID_KT = TL1.TLNANME
		LEFT JOIN TL_USER TL2 ON TR.CHECKER_ID_KT = TL2.TLNANME
		LEFT JOIN CM_ALLCODE AL ON A.PAY_TYPE = AL.CDVAL AND AL.CDNAME='TR_REQ' AND AL.CDTYPE ='REQ_JOB'
		WHERE 1 = 1 AND A.REQ_ID = @p_REQ_ID
		AND TR.AUTH_STATUS_KT = 'A'
		AND A.PAY_TYPE = @p_PAY_TYPE
		ORDER BY A.CREATE_DT DESC
-- PAGING END
	END
	ELSE
	BEGIN
-- PAGING BEGIN
SELECT TOP(CONVERT(INT,@P_TOP))A.REQ_PAY_ID, TR.REQ_PAY_CODE, CMB.BRANCH_NAME, CMD.DEP_NAME, A.PAY_AMT, A.PAY_PHASE, A.PAY_DESC, A.PAY_TYPE, AL.CONTENT AS PAY_TYPE_NAME,
TR.CREATE_DT, TL1.TLFullName AS GDV, TL2.TLFullName AS KSV, TR.APPROVE_DT_KT
-- SELECT END
        FROM TR_REQ_PAY_JOB A
		LEFT JOIN TR_REQ_PAYMENT TR ON A.REQ_PAY_ID = TR.REQ_PAY_ID
		LEFT JOIN CM_BRANCH CMB ON TR.BRANCH_ID = CMB.BRANCH_ID
		LEFT JOIN CM_DEPARTMENT CMD ON TR.DEP_ID = CMD.DEP_ID
		LEFT JOIN TL_USER TL1 ON TR.MAKER_ID_KT = TL1.TLNANME
		LEFT JOIN TL_USER TL2 ON TR.CHECKER_ID_KT = TL2.TLNANME
		LEFT JOIN CM_ALLCODE AL ON A.PAY_TYPE = AL.CDVAL AND AL.CDNAME='TR_REQ' AND AL.CDTYPE ='REQ_JOB'
		WHERE 1 = 1 AND A.REQ_ID = @p_REQ_ID
		AND TR.AUTH_STATUS_KT = 'A'
		AND A.PAY_TYPE = @p_PAY_TYPE
		ORDER BY A.CREATE_DT DESC
-- PAGING END
    END;
END -- PAGING