ALTER FUNCTION [dbo].[FN_GET_ACC_NAME_PAY](@p_ACC_NO varchar(100))
	returns nvarchar(500)
AS
BEGIN
	-- LUCTV 03062020 BO BANG ACCOUNT BAO GOM ACCOUNT VA ACCOUNT PAY
	DECLARE  @TABLE_ACCOUNT TABLE (ACC_NO VARCHAR(100), ACC_NAME VARCHAR(1000))
	INSERT INTO @TABLE_ACCOUNT SELECT ACC_NO, ACC_NAME FROM CM_ACCOUNT
	--INSERT INTO @TABLE_ACCOUNT SELECT ACC_NUM, ACC_NAME FROM CM_ACCOUNT_PAY
	--INSERT INTO @TABLE_ACCOUNT SELECT ACC_NUM, ACC_NAME FROM CM_SUPPLIER
	--INSERT INTO @TABLE_ACCOUNT SELECT ACC_NUM_OUT, ACC_NAME_OUT FROM CM_SUPPLIER
	---
	declare @l_ACC_NAME nvarchar(500)		
	SELECT @l_ACC_NAME = ACC_NAME FROM @TABLE_ACCOUNT WHERE ACC_NO = @p_ACC_NO
	--IF LEN(@p_ACC_NO) > 9
	--BEGIN 
	--	SELECT @l_ACC_NAME = DAO_NAME FROM CM_BRANCH WHERE DAO_CODE = @p_ACC_NO
	--END	
	--ELSE
	--BEGIN
				
	--END
	
	RETURN @l_ACC_NAME
END