ALTER PROCEDURE [dbo].[ASS_GROUP_ByCondition]
	@p_TYPE_ID varchar(15) = NULL,
	@p_ASS_CAT varchar(15) = NULL
AS

BEGIN
	--khangth,27/03/2020 searching ass group by type and category
	SELECT * 
	FROM ASS_GROUP A
	WHERE ([TYPE_ID] = @p_TYPE_ID OR @p_TYPE_ID IS NULL OR @p_TYPE_ID = '')
	--AND (ASS_CAT = @p_ASS_CAT OR @p_ASS_CAT IS NULL OR @p_ASS_CAT = '')
	AND RECORD_STATUS = '1'
	AND AUTH_STATUS = 'A'
		--and IS_LEAF='Y'
		--AND ISNULL(A.ASSET_ACCTNO,'') <> '' 
		--AND ISNULL(A.AMORT_ACCTNO,'') <> ''
		--AND ISNULL(A.EXP_ACCTNO,'') <> ''
		--AND ISNULL(A.INC_ACCTNO,'') <> ''
		--AND ISNULL(A.LIQ_ACCTNO,'') <> ''		
	ORDER BY GROUP_CODE 
End