ALTER PROCEDURE [dbo].[PL_IMPORT_LOG_GetByID]
	@p_IMPORT_ID	varchar(15)  = NULL
AS
BEGIN

		SELECT A.IMP_LOG_CODE, A.FILE_NAME,A.CREATE_DT,A.APPROVE_DT,MA.TLFullName AS MAKER_NAME,AP.TLFullName AS APPROVE_NAME
		FROM dbo.PL_IMPORT_LOG A 
		
		LEFT JOIN dbo.TL_USER MA ON MA.TLNANME=A.EDITER_ID
		LEFT JOIN dbo.TL_USER AP ON AP.TLNANME=A.CHECKER_ID
	
		WHERE 1 = 1
		AND A.IMP_ID=@p_IMPORT_ID
		AND A.RECORD_STATUS = '1'
		GROUP BY A.IMP_LOG_CODE , A.FILE_NAME,A.CREATE_DT,A.APPROVE_DT,MA.TLFullName,AP.TLFullName
		ORDER BY A.CREATE_DT DESC
END