CREATE  PROCEDURE [dbo].[TR_REQ_JOB_ByUserName]
	@p_UserName	varchar(100)
AS
	begin -- PAGING
		 -- PAGING BEGIN
		SELECT A.[ID]
			  ,A.[EMP_CODE]
			  ,A.[EMP_NAME]
			  ,A.[BRANCH_CODE]
			  ,A.[DEP_CODE]
			  ,A.[USER_DOMAIN]
			  ,A.[POS_CODE]
			  ,A.[POS_NAME]
			  ,A.[CREATE_DT]
			  ,B.[EMP_PHONE]
		 -- SELECT END
		FROM CM_EMPLOYEE_LOG A
		LEFT JOIN(SELECT TOP(1)* FROM dbo.TR_REQUEST_JOB_FORM WHERE MAKER_ID=@p_UserName AND EMP_PHONE IS NOT NULL ORDER BY CREATE_DT DESC ) B ON A.USER_DOMAIN = B.MAKER_ID
		WHERE  USER_DOMAIN= @p_UserName
		 -- PAGING END
	end -- PAGING