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 <> 'ET')
	BEGIN
		SELECT TOP 1 A.*,'' AS REF_CODE, '' AS REF_NAME, 'ADV_PAY' AS ACC_TYPE
		FROM CM_ACCOUNT_PAY A
		WHERE A.REF_ID = @p_REF_ID
	END
ELSE
	BEGIN
		SELECT TOP 1 A.*,'' AS REF_CODE, '' AS REF_NAME, 'ET' AS ACC_TYPE
		FROM CM_ACCOUNT A
		WHERE A.ACC_NO = @p_REF_ID
	END
END