DECLARE  @User TABLE
(USERNAME VARCHAR(50), 
 KSV NVARCHAR(500), 
 GDV_NAME NVARCHAR(500),
 BRANDNAME NVARCHAR(1000),
 ID VARCHAR(20)
)
DECLARE @p_REF_ID VARCHAR(15)='ASSL00000005362'
DECLARE  @TRN_TYPE VARCHAR(15)
SET @TRN_TYPE =(SELECT TRN_TYPE FROM ASS_ENTRIES_POST A WHERE A.TRN_ID = @p_REF_ID)
IF(@TRN_TYPE='ADD_NEW')
	BEGIN
		INSERT INTO @User
		SELECT A.MAKER_ID AS USERNAME,
				UM3.TLFullName AS KSV,
				UM4.TLFullName AS GDV_NAME,
				BR.BRANCH_NAME AS BRANDNAME,
				A.ADDNEW_ID
			FROM ASS_ADDNEW A
				LEFT JOIN TL_USER UM3 ON UM3.TLNANME = A.CHECKER_ID_KT
				LEFT JOIN TL_USER UM4 ON UM4.TLNANME = A.MAKER_ID_KT
				LEFT JOIN CM_BRANCH BR ON BR.BRANCH_ID = A.BRANCH_CREATE
			WHERE ADDNEW_ID = @p_REF_ID
	END
ELSE IF(@TRN_TYPE='ASS_UPDATE')
	BEGIN
		INSERT INTO @User
		SELECT A.MAKER_ID AS USERNAME,
				UM3.TLFullName AS KSV,
				UM4.TLFullName AS GDV_NAME,
				BR.BRANCH_NAME AS BRANDNAME,
				A.UPDATE_ID
			FROM dbo.ASS_UPDATE A
				LEFT JOIN TL_USER UM3 ON UM3.TLNANME = A.CHECKER_ID
				LEFT JOIN TL_USER UM4 ON UM4.TLNANME = A.MAKER_ID
				LEFT JOIN CM_BRANCH BR ON BR.BRANCH_ID = A.BRANCH_ID
			WHERE UPDATE_ID = @p_REF_ID
	END
ELSE IF(@TRN_TYPE='LIQ')
	BEGIN
		INSERT INTO @User
		SELECT A.MAKER_ID AS USERNAME,
				UM3.TLFullName AS KSV,
				UM4.TLFullName AS GDV_NAME,
				BR.BRANCH_NAME AS BRANDNAME,
				A.LIQ_ID
			FROM dbo.ASS_LIQUIDATION A
				LEFT JOIN TL_USER UM3 ON UM3.TLNANME = A.CHECKER_ID_KT
				LEFT JOIN TL_USER UM4 ON UM4.TLNANME = A.MAKER_ID_KT
				LEFT JOIN CM_BRANCH BR ON BR.BRANCH_ID = A.BRANCH_ID
			WHERE LIQ_ID = @p_REF_ID
	END
SELECT * FROM @User