ALTER PROC [dbo].[CM_ACCOUNT_BYID]
@p_ACC_NO VARCHAR(15) = NULL
AS
BEGIN
SELECT TOP 1 A.*
FROM CM_ACCOUNT A
WHERE A.ACC_NO = @p_ACC_NO
END