ALTER PROCEDURE [dbo].[PL_PROCESS_SEARCH]
	@p_REQ_ID VARCHAR(20)=NULL,
	@p_USER_LOGIN VARCHAR(20)=NULL,
	@p_TYPE VARCHAR(20)=NULL
AS
BEGIN
	 SELECT PR.ID,
            PR.REQ_ID,
            PR.PROCESS_ID,
            PR.CHECKER_ID,
            PR.APPROVE_DT,
            PR.PROCESS_DESC,
            PR.NOTES,
			TU.TLFullName AS CHECKER_NAME
			FROM dbo.PL_PROCESS PR 
	 --LEFT JOIN dbo.PL_REQUEST_DOC PD ON PD.REQ_ID=PR.REQ_ID
	 LEFT JOIN dbo.TL_USER TU ON TU.TLNANME=PR.CHECKER_ID
	 WHERE PR.REQ_ID=@p_REQ_ID
	 ORDER BY APPROVE_DT DESC
	 
END