ALTER PROC [dbo].[TR_REQ_KPI_Search]
@p_TYPE_REPORT VARCHAR(250) = NULL,
@p_ROLE VARCHAR(20) = NULL,
@p_MAKER_ID VARCHAR(20) = NULL,
@p_USER_LOGIN VARCHAR(50) = NULL,
@p_FRM_DATE VARCHAR(20) = NULL,
@p_TO_DATE VARCHAR(20) = NULL,
@p_AUTH_STATUS_KT VARCHAR(20) = NULL,
@p_TOP INT = NULL
AS
BEGIN -- PAGING
	DECLARE @p_FROM_DT DATE, @p_TO_DT DATE
	SET @p_FROM_DT =CONVERT(DATE,@p_FRM_DATE,103)
	SET @p_TO_DT =CONVERT(DATE,@p_TO_DATE,103)

	IF (@p_TYPE_REPORT='ASS')
	BEGIN
	-- PAGING BEGIN
		SELECT H.*
	-- SELECT END
		FROM
		(
			SELECT ADDNEW_ID AS MA_SO_PHIEU, A.CORE_NOTE AS NOI_DUNG,
			CONVERT(VARCHAR,MONTH(A.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.APPROVE_DT),2) AS NGAY_NHAN_PHIEU, 
			MAKER_ID_KT AS GDV,
			CONVERT(VARCHAR,MONTH(CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(CREATE_DT_KT),2) AS NGAY_GDV_GUI_DUYET, 
			CHECKER_ID_KT AS KSV,
			CONVERT(VARCHAR,MONTH(APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(APPROVE_DT_KT),2) AS NGAY_KSV_DUYET
			FROM ASS_ADDNEW A
			WHERE 1=1
			AND (CREATE_DT_KT >=@p_FROM_DT OR APPROVE_DT_KT  >=@p_FROM_DT OR @p_FRM_DATE IS NULL OR @p_FRM_DATE ='') 
			AND (CREATE_DT_KT <=@p_TO_DT OR APPROVE_DT_KT  <=@p_TO_DT OR @p_TO_DATE IS NULL OR @p_TO_DATE ='')
			AND MAKER_ID_KT IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')
			UNION
			SELECT USER_MASTER_ID AS MA_SO_PHIEU, A.CORE_NOTE AS NOI_DUNG, 
			CONVERT(VARCHAR,MONTH(APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(APPROVE_DT),2) AS NGAY_NHAN_PHIEU, 
			MAKER_ID_KT AS GDV,
			CONVERT(VARCHAR,MONTH(CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(CREATE_DT_KT),2) AS NGAY_GDV_GUI_DUYET, 
			CHECKER_ID_KT AS KSV,
			CONVERT(VARCHAR,MONTH(APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(APPROVE_DT_KT),2) AS NGAY_KSV_DUYET
			FROM dbo.ASS_USE_MULTI_MASTER A
			WHERE 1=1
			AND (CREATE_DT_KT >=@p_FROM_DT OR APPROVE_DT_KT  >=@p_FROM_DT OR @p_FRM_DATE IS NULL OR @p_FRM_DATE ='') 
			AND (CREATE_DT_KT <=@p_TO_DT OR APPROVE_DT_KT  <=@p_TO_DT OR @p_TO_DATE IS NULL OR @p_TO_DATE ='')
			AND MAKER_ID_KT IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')
			UNION
			SELECT TRANS_MULTI_MASTER_ID AS MA_SO_PHIEU, A.CORE_NOTE AS NOI_DUNG, 
			CONVERT(VARCHAR,MONTH(APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(APPROVE_DT),2) AS NGAY_NHAN_PHIEU, 
			MAKER_ID_KT AS GDV,
			CONVERT(VARCHAR,MONTH(CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(CREATE_DT_KT),2) AS NGAY_GDV_GUI_DUYET, 
			CHECKER_ID_KT AS KSV,
			CONVERT(VARCHAR,MONTH(APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(APPROVE_DT_KT),2) AS NGAY_KSV_DUYET
			FROM dbo.ASS_TRANSFER_MULTI_MASTER A
			WHERE 1=1
			AND (CREATE_DT_KT >=@p_FROM_DT OR APPROVE_DT_KT  >=@p_FROM_DT OR @p_FRM_DATE IS NULL OR @p_FRM_DATE ='') 
			AND (CREATE_DT_KT <=@p_TO_DT OR APPROVE_DT_KT  <=@p_TO_DT OR @p_TO_DATE IS NULL OR @p_TO_DATE ='')
			AND MAKER_ID_KT IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')
			UNION
			SELECT COL_MULTI_MASTER_ID AS MA_SO_PHIEU, A.CORE_NOTE AS NOI_DUNG,
			CONVERT(VARCHAR,MONTH(APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(APPROVE_DT),2) AS NGAY_NHAN_PHIEU, 
			MAKER_ID_KT AS GDV,
			CONVERT(VARCHAR,MONTH(CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(CREATE_DT_KT),2) AS NGAY_GDV_GUI_DUYET, 
			CHECKER_ID_KT AS KSV,
			CONVERT(VARCHAR,MONTH(APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(APPROVE_DT_KT),2) AS NGAY_KSV_DUYET
			FROM dbo.ASS_COLLECT_MULTI_MASTER A
			WHERE 1=1
			AND (CREATE_DT_KT >=@p_FROM_DT OR APPROVE_DT_KT  >=@p_FROM_DT OR @p_FRM_DATE IS NULL OR @p_FRM_DATE ='') 
			AND (CREATE_DT_KT <=@p_TO_DT OR APPROVE_DT_KT  <=@p_TO_DT OR @p_TO_DATE IS NULL OR @p_TO_DATE ='')
			AND MAKER_ID_KT IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')
			UNION
			SELECT LIQ_ID AS MA_SO_PHIEU, A.CORE_NOTE AS NOI_DUNG,
			CONVERT(VARCHAR,MONTH(APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(APPROVE_DT),2) AS NGAY_NHAN_PHIEU, 
			MAKER_ID_KT AS GDV,
			CONVERT(VARCHAR,MONTH(CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(CREATE_DT_KT),2) AS NGAY_GDV_GUI_DUYET, 
			CHECKER_ID_KT AS KSV,
			CONVERT(VARCHAR,MONTH(APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(APPROVE_DT_KT),2) AS NGAY_KSV_DUYET
			FROM dbo.ASS_LIQUIDATION A
			WHERE 1=1 
			AND (CREATE_DT_KT >=@p_FROM_DT OR APPROVE_DT_KT  >=@p_FROM_DT OR @p_FRM_DATE IS NULL OR @p_FRM_DATE ='') 
			AND (CREATE_DT_KT <=@p_TO_DT OR APPROVE_DT_KT  <=@p_TO_DT OR @p_TO_DATE IS NULL OR @p_TO_DATE ='')
			AND MAKER_ID_KT IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')
		) H
	-- PAGING END
	END
	ELSE IF (@p_TYPE_REPORT='MW')
	BEGIN
	-- PAGING BEGIN
		SELECT H.*
	-- SELECT END
		FROM
		(
			SELECT A.IN_CODE AS MA_SO_PHIEU, A.CORE_NOTE AS NOI_DUNG,
			CONVERT(VARCHAR,MONTH(A.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.APPROVE_DT),2) AS NGAY_NHAN_PHIEU, 
			A.MAKER_ID_KT AS GDV, 
			CONVERT(VARCHAR,MONTH(A.CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(A.CREATE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(A.CREATE_DT_KT),2) AS NGAY_GDV_GUI_DUYET, 
			CHECKER_ID_KT AS KSV,
			CONVERT(VARCHAR,MONTH(A.APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,DAY(A.APPROVE_DT_KT),2) +'/'+CONVERT(VARCHAR,YEAR(A.APPROVE_DT_KT),2) AS NGAY_KSV_DUYET
			FROM MW_IN_MASTER A
			WHERE 1=1
			AND A.AUTH_STATUS ='A'
			AND (	((ISNULL(@p_FROM_DT, '') = '' OR A.CREATE_DT_KT >=@p_FROM_DT ) AND A.CREATE_DT_KT <=@p_TO_DT)
					OR (( ISNULL(@p_FROM_DT, '') = '' OR A.APPROVE_DT_KT >=@p_FROM_DT) AND A.APPROVE_DT_KT <=@p_TO_DT)
				)
			--AND (ISNULL(A.CREATE_DT_KT,'') <> '' AND A.CREATE_DT_KT >= CONVERT(DATE, @p_FRM_DATE, 103)) OR (ISNULL(A.APPROVE_DT_KT,'') <> '' AND A.APPROVE_DT_KT >= CONVERT(DATE, @p_FRM_DATE, 103))
			--AND (ISNULL(A.CREATE_DT_KT,'') <> '' AND A.CREATE_DT_KT <= CONVERT(DATE, @p_TO_DATE, 103)) OR (ISNULL(A.APPROVE_DT_KT,'') <> '' AND A.APPROVE_DT_KT <= CONVERT(DATE, @p_TO_DATE, 103))
			AND A.MAKER_ID_KT IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')
			AND (ISNULL(A.MAKER_ID_KT, '') = @p_MAKER_ID OR @p_MAKER_ID = '' OR @p_MAKER_ID IS NULL)
			AND (	(@p_ROLE = 'GDV' AND A.AUTH_STATUS_KT IN('A', 'U') AND ISNULL(A.CREATE_DT_KT, '') <> '') 
					OR (@p_ROLE = 'KSV' AND A.AUTH_STATUS_KT IN ('A')) 
					OR (ISNULL(@p_ROLE, '') = '' AND A.AUTH_STATUS_KT IN('A', 'U') AND ISNULL(A.CREATE_DT_KT, '') <> '') 
				)
			UNION
			SELECT OUT_CODE AS MA_SO_PHIEU, A.CORE_NOTE AS NOI_DUNG,
			CONVERT(VARCHAR,MONTH(A.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.APPROVE_DT),2) AS NGAY_NHAN_PHIEU, 
			A.KT_MAKER_ID AS GDV, 
			CONVERT(VARCHAR,MONTH(A.KT_CREATE_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.KT_CREATE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.KT_CREATE_DT),2) AS NGAY_GDV_GUI_DUYET, 
			KT_CHECKER_ID AS KSV, 
			CONVERT(VARCHAR,MONTH(A.KT_APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.KT_APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.KT_APPROVE_DT),2) AS NGAY_KSV_DUYET 
			FROM MW_OUT A
			WHERE 1=1 
			AND A.AUTH_STATUS ='A'
			AND (	((ISNULL(@p_FROM_DT, '') = '' OR A.KT_CREATE_DT >=@p_FROM_DT) AND A.KT_CREATE_DT <=@p_TO_DT)
					OR ((ISNULL(@p_FROM_DT, '') = '' OR A.KT_APPROVE_DT >=@p_FROM_DT) AND A.KT_APPROVE_DT <=@p_TO_DT)
				)
			--AND (ISNULL(A.KT_CREATE_DT,'') <> '' AND A.KT_CREATE_DT >= CONVERT(DATE, @p_FRM_DATE, 103)) OR (ISNULL(A.KT_APPROVE_DT,'') <> '' AND A.KT_APPROVE_DT >= CONVERT(DATE, @p_FRM_DATE, 103))
			--AND (ISNULL(A.KT_CREATE_DT,'') <> '' AND A.KT_CREATE_DT <= CONVERT(DATE, @p_TO_DATE, 103)) OR (ISNULL(A.KT_APPROVE_DT,'') <> '' AND A.KT_APPROVE_DT <= CONVERT(DATE, @p_TO_DATE, 103))
			AND A.KT_MAKER_ID IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')
			AND (ISNULL(A.KT_MAKER_ID, '') = @p_MAKER_ID OR @p_MAKER_ID = '' OR @p_MAKER_ID IS NULL)
			AND (	(@p_ROLE = 'GDV' AND A.KT_AUTH_STATUS IN('A', 'U') AND ISNULL(A.KT_CREATE_DT, '') <> '') 
					OR (@p_ROLE = 'KSV' AND A.KT_AUTH_STATUS IN ('A')) 
					OR (ISNULL(@p_ROLE, '') = '' AND A.KT_AUTH_STATUS IN('A', 'U') AND ISNULL(A.KT_CREATE_DT, '') <> '') 
				)
			UNION
			SELECT A.TRANSFER_CODE AS MA_SO_PHIEU, A.CORE_NOTE AS NOI_DUNG, 
			CONVERT(VARCHAR,MONTH(A.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.APPROVE_DT),2) AS NGAY_NHAN_PHIEU, 
			A.KT_MAKER_ID AS GDV, 
			CONVERT(VARCHAR,MONTH(A.KT_CREATE_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.KT_CREATE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.KT_CREATE_DT),2) AS NGAY_GDV_GUI_DUYET, 
			A.KT_CHECKER_ID AS KSV, 
			CONVERT(VARCHAR,MONTH(A.KT_APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.KT_APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.KT_APPROVE_DT),2) AS NGAY_KSV_DUYET 
			FROM MW_TRANSFER A
			WHERE 1=1 
			AND A.AUTH_STATUS ='A'
			AND (	((A.KT_CREATE_DT >=@p_FROM_DT OR ISNULL(@p_FROM_DT, '') = '') AND A.KT_CREATE_DT <=@p_TO_DT)
					OR ((A.KT_APPROVE_DT >=@p_FROM_DT OR ISNULL(@p_FROM_DT, '') = '') AND A.KT_APPROVE_DT <=@p_TO_DT)
				)
			--AND (ISNULL(A.KT_CREATE_DT,'') <> '' AND A.KT_CREATE_DT >= CONVERT(DATE, @p_FRM_DATE, 103)) OR (ISNULL(A.KT_APPROVE_DT,'') <> '' AND A.KT_APPROVE_DT >= CONVERT(DATE, @p_FRM_DATE, 103))
			--AND (ISNULL(A.KT_CREATE_DT,'') <> '' AND A.KT_CREATE_DT <= CONVERT(DATE, @p_TO_DATE, 103)) OR (ISNULL(A.KT_APPROVE_DT,'') <> '' AND A.KT_APPROVE_DT <= CONVERT(DATE, @p_TO_DATE, 103))
			AND A.KT_MAKER_ID IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')
			AND (ISNULL(A.KT_MAKER_ID, '') = @p_MAKER_ID OR @p_MAKER_ID = '' OR @p_MAKER_ID IS NULL)
			AND (	(@p_ROLE = 'GDV' AND A.KT_AUTH_STATUS IN('A', 'U') AND ISNULL(A.KT_CREATE_DT, '') <> '') 
					OR (@p_ROLE = 'KSV' AND A.KT_AUTH_STATUS IN ('A')) 
					OR (ISNULL(@p_ROLE, '') = '' AND A.KT_AUTH_STATUS IN('A', 'U') AND ISNULL(A.KT_CREATE_DT, '') <> '') 
				)
			UNION
			SELECT A.LIQ_CODE AS MA_SO_PHIEU, A.CORE_NOTE AS NOI_DUNG, 
			CONVERT(VARCHAR,MONTH(A.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.APPROVE_DT),2) AS NGAY_NHAN_PHIEU, 
			A.KT_MAKER_ID AS GDV, 
			CONVERT(VARCHAR,MONTH(A.KT_CREATE_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.KT_CREATE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.KT_CREATE_DT),2) AS NGAY_GDV_GUI_DUYET, 
			A.KT_CHECKER_ID AS KSV, 
			CONVERT(VARCHAR,MONTH(A.KT_APPROVE_DT),2) +'/'+CONVERT(VARCHAR,DAY(A.KT_APPROVE_DT),2) +'/'+CONVERT(VARCHAR,YEAR(A.KT_APPROVE_DT),2) AS NGAY_KSV_DUYET 
			FROM MW_LIQ_MASTER A
			WHERE 1=1 
			AND A.AUTH_STATUS ='A'
			AND (	((A.KT_CREATE_DT >=@p_FROM_DT OR ISNULL(@p_FROM_DT, '') = '')  AND A.KT_CREATE_DT <=@p_TO_DT)
					OR ((A.KT_APPROVE_DT >=@p_FROM_DT OR ISNULL(@p_FROM_DT, '') = '') AND A.KT_APPROVE_DT <=@p_TO_DT)
				)
			--AND (ISNULL(A.KT_CREATE_DT,'') <> '' AND A.KT_CREATE_DT >= CONVERT(DATE, @p_FRM_DATE, 103)) OR (ISNULL(A.KT_APPROVE_DT,'') <> '' AND A.KT_APPROVE_DT >= CONVERT(DATE, @p_FRM_DATE, 103))
			--AND (ISNULL(A.KT_CREATE_DT,'') <> '' AND A.KT_CREATE_DT <= CONVERT(DATE, @p_TO_DATE, 103)) OR (ISNULL(A.KT_APPROVE_DT,'') <> '' AND A.KT_APPROVE_DT <= CONVERT(DATE, @p_TO_DATE, 103))
			AND A.KT_MAKER_ID IN (SELECT TLNANME FROM TL_USER WHERE SECUR_CODE ='DEP000000000022')
			AND (ISNULL(A.KT_MAKER_ID, '') = @p_MAKER_ID OR @p_MAKER_ID = '' OR @p_MAKER_ID IS NULL)
			AND (	(@p_ROLE = 'GDV' AND A.KT_AUTH_STATUS IN('A', 'U') AND ISNULL(A.KT_CREATE_DT, '') <> '') 
					OR (@p_ROLE = 'KSV' AND A.KT_AUTH_STATUS IN ('A')) 
					OR (ISNULL(@p_ROLE, '') = '' AND A.KT_AUTH_STATUS IN('A', 'U') AND ISNULL(A.KT_CREATE_DT, '') <> '') 
				)
		) H
	-- PAGING END	
	END
	ELSE IF (@p_TYPE_REPORT='PAY')
	BEGIN
	-- PAGING BEGIN
		SELECT H.*
	-- SELECT END
		FROM	
		(
			SELECT A.REQ_PAY_CODE AS MA_SO_PHIEU,A.REQ_REASON AS NOI_DUNG, A.REQ_AMT AS SO_TIEN_THANH_TOAN_TAM_UNG,
			A.TRANSFER_DT  AS NGAY_NHAN_PHIEU,
			A.MAKER_ID_KT AS GDV,
			A.CREATE_DT_KT AS NGAY_GDV_GUI_DUYET,
			A.CHECKER_ID_KT AS KSV, 
			A.APPROVE_DT_KT AS NGAY_KSV_DUYET, A.AUTH_STATUS_KT, B.AUTH_STATUS_NAME AS AUTH_STATUS_KT_NAME
			FROM TR_REQ_PAYMENT A
			LEFT JOIN CM_AUTH_STATUS B ON A.AUTH_STATUS_KT = B.AUTH_STATUS
			LEFT JOIN PL_PROCESS PR ON A.REF_ID = PR.REQ_ID AND PR.PROCESS_ID =N'Trả về' AND PR.CHECKER_ID IN ('huongvt','nghihm','hainth','khuyenlnb')
			WHERE 1=1
			AND (	(A.TRANSFER_DT >= @p_FROM_DT AND A.TRANSFER_DT <=@p_TO_DT)
					OR (A.CREATE_DT_KT >=@p_FROM_DT AND A.CREATE_DT_KT <=@p_TO_DT)
					OR (A.APPROVE_DT_KT >=@p_FROM_DT AND A.APPROVE_DT_KT <=@p_TO_DT)
				)
			AND A.AUTH_STATUS ='A'
			AND (	(@p_ROLE = 'GDV' AND A.AUTH_STATUS_KT IN('A', 'P', 'S')) 
					OR (@p_ROLE = 'KSV' AND A.AUTH_STATUS_KT IN ('A')) 
					OR (ISNULL(@p_ROLE, '') = '' AND A.AUTH_STATUS_KT IN('A', 'P', 'S')) )
			AND (A.MAKER_ID_KT = @p_MAKER_ID OR @p_MAKER_ID = '' OR @p_MAKER_ID IS NULL)

			UNION

			SELECT A.REQ_PAY_CODE AS MA_SO_PHIEU,A.REQ_REASON AS NOI_DUNG, A.REQ_AMT AS SO_TIEN_THANH_TOAN_TAM_UNG, 
			A.TRANSFER_DT  AS NGAY_NHAN_PHIEU,
			A.MAKER_ID_KT AS GDV,
			A.CREATE_DT_KT AS NGAY_GDV_GUI_DUYET,
			A.CHECKER_ID_KT AS KSV, 
			A.APPROVE_DT_KT AS NGAY_KSV_DUYET, A.AUTH_STATUS_KT, B.AUTH_STATUS_NAME AS AUTH_STATUS_KT_NAME

			FROM TR_REQ_ADVANCE_PAYMENT A
			LEFT JOIN CM_AUTH_STATUS B ON A.AUTH_STATUS_KT = B.AUTH_STATUS
			WHERE 1=1
			AND (	(A.TRANSFER_DT >= @p_FROM_DT AND A.TRANSFER_DT <=@p_TO_DT)
					OR (A.CREATE_DT_KT >=@p_FROM_DT AND A.CREATE_DT_KT <=@p_TO_DT)
					OR (A.APPROVE_DT_KT >=@p_FROM_DT AND A.APPROVE_DT_KT <=@p_TO_DT)
				)
			AND A.AUTH_STATUS ='A'
			AND (	(@p_ROLE = 'GDV' AND A.AUTH_STATUS_KT IN('A', 'P', 'S')) 
					OR (@p_ROLE = 'KSV' AND A.AUTH_STATUS_KT IN ('A')) 
					OR (ISNULL(@p_ROLE, '') = '' AND A.AUTH_STATUS_KT IN('A', 'P', 'S')) )
			AND (A.MAKER_ID_KT = @p_MAKER_ID OR @p_MAKER_ID = '' OR @p_MAKER_ID IS NULL)
		) H
	-- PAGING END
	END
END -- PAGING