ALTER   PROC [dbo].[CM_ACCOUNT_PAY_BYID]
@p_REF_ID VARCHAR(15) = NULL,
@p_ACC_TYPE VARCHAR(50) = NULL
AS
BEGIN
	IF(@p_ACC_TYPE = 'ADV_PAY')
	BEGIN
		SELECT TOP 1 A.*,'' AS REF_CODE, '' AS REF_NAME, 'ADV_PAY' AS ACC_TYPE, A.ACC_NUM ACC_NO, B.CONTENT AS AUTH_STATUS_NAME
		FROM CM_ACCOUNT_PAY A
		LEFT JOIN CM_ALLCODE B ON A.AUTH_STATUS = B.CDVAL AND B.CDNAME = 'AUTH_STATUS' AND B.CDTYPE = 'AUTH_STATUS'
		WHERE A.ACC_NUM = @p_REF_ID
	END
	ELSE
	BEGIN
		SELECT TOP 1 A.*,'' AS REF_CODE, '' AS REF_NAME, 
		CASE
			WHEN LEN(A.ACC_NO) > 9 THEN 'CASA'
			ELSE 'GL'
		END AS ACC_TYPE, 
		B.CONTENT AS AUTH_STATUS_NAME
		FROM CM_ACCOUNT A
		LEFT JOIN CM_ALLCODE B ON A.AUTH_STATUS = B.CDVAL AND B.CDNAME = 'AUTH_STATUS' AND B.CDTYPE = 'AUTH_STATUS'
		WHERE A.ACC_NO = @p_REF_ID
	END
END