ALTER   PROC [dbo].[rpt_TR_REQ_PAY_Drive_DT_ById]
@p_REQ_PAY_ID varchar(15) = NULL,
@p_BRANCH_ID varchar(15) = NULL,
@p_DEP_ID varchar(15) = NULL,
@p_CHECKR_ID varchar(15) = NULL,
@p_CHECKR_ID_KT varchar(15) = NULL,
@p_APPROVE_DT_KT varchar(15) = NULL
AS
BEGIN
	SELECT TR.CREATE_DT, A.*, N'Nhiên liệu' AS PAY_TYPE_NAME, TR.REQ_PAY_CODE, BR.BRANCH_NAME, DP.DEP_NAME, GDV.TLFullName AS GDV, KSV.TLFullName AS KSV
	FROM TR_REQ_PAY_DRIVE_DT A 
	LEFT JOIN TR_REQ_PAYMENT TR ON A.REQ_PAY_ID = TR.REQ_PAY_ID
	LEFT JOIN CM_BRANCH BR ON BR.BRANCH_ID = @p_BRANCH_ID
	LEFT JOIN CM_DEPARTMENT DP ON DP.DEP_ID = @p_DEP_ID
	LEFT JOIN TL_USER KSV ON KSV.TLNANME = @p_CHECKR_ID
	LEFT JOIN TL_USER GDV ON GDV.TLNANME = @p_CHECKR_ID_KT
	WHERE A.REQ_PAY_ID =@p_REQ_PAY_ID

	SELECT TOP 1 A.PAY_PHASE
	FROM TR_REQ_PAY_DRIVE_DT A 
	WHERE A.REQ_PAY_ID =@p_REQ_PAY_ID
END