ALTER PROCEDURE dbo.ASS_ENTRIES_POST_Lst
	@p_DATE varchar(10),
	@p_BRANCH_ID varchar(15) = '',
	@p_MAKER_ID VARCHAR(100) = NULL
AS
    DECLARE @p_BRANCH_CODE VARCHAR(20) = (SELECT CB.BRANCH_CODE FROM CM_BRANCH CB WHERE CB.BRANCH_ID = @p_BRANCH_ID)
	--LAY MA DON VI CUA HS NEU TIM THEO HS
	IF @p_BRANCH_ID = 'HS'
	BEGIN
		SELECT @p_BRANCH_ID = BRANCH_ID FROM CM_BRANCH WHERE BRANCH_TYPE = 'HS'
	END
	SELECT  A.*, TU2.TLFullName AS USER_NAME, TU.TLFullName AS AUTH_NAME
	FROM ASS_ENTRIES_POST_SYNC A
    LEFT JOIN TL_USER TU ON A.AUTH_ID = TU.TLNANME
    LEFT JOIN TL_USER TU2 ON A.USER_ID = TU2.TLNANME
	WHERE DATEDIFF(DAYOFYEAR,A.TRN_DT,CONVERT(datetime, @p_DATE,103)) = 0