ALTER PROC [dbo].[TR_REQ_PAY_METHOD_Search]
@p_ACC_NO varchar(15),
@p_ACC_NAME varchar(15),
@p_ISSUED_BY varchar(250),
@p_ISSUED_DT VARCHAR(20)
AS
BEGIN
	SELECT MAX(A.ACC_NO) AS ACC_NO, MAX(A.ACC_NAME) AS ACC_NAME, MAX(A.ISSUED_BY) AS ISSUED_BY  , MAX(A.ISSUED_DT) AS ISSUED_DT
	FROM TR_REQ_PAY_METHOD A
	WHERE (A.ACC_NO <> NULL OR A.ACC_NO <> '') AND (A.ACC_NAME <> NULL OR A.ACC_NAME <> '')
	AND (A.ACC_NO LIKE '%' + @p_ACC_NO + '%' OR  @p_ACC_NO IS NULL OR @p_ACC_NO = '')
	AND (A.ACC_NAME LIKE '%' + @p_ACC_NAME + '%' OR  @p_ACC_NAME IS NULL OR @p_ACC_NAME = '')
	AND (A.ISSUED_BY LIKE '%' + @p_ISSUED_BY + '%' OR  @p_ISSUED_BY IS NULL OR @p_ISSUED_BY = '')
	AND (A.ISSUED_DT LIKE '%' + @p_ISSUED_DT + '%' OR  @p_ISSUED_DT IS NULL OR @p_ISSUED_DT = '')
	GROUP BY A.ACC_NO, A.CHECK_IN
END