USP_APPUSER_GETAPPUSERINFO_FROM_CUSTOM_AUTHENTICATION_USERID

CREATE procedure dbo.USP_APPUSER_GETAPPUSERINFO_FROM_CUSTOM_AUTHENTICATION_USERID(@CUSTOM_AUTHENTICATION_USERID nvarchar(255))
as
begin
     select
        ID,
        ISSYSADMIN,
        DISPLAYNAME,
        EMAILADDRESS,
        cast(isnull(APPUSER.ISACTIVE, 1) as bit) as ISACTIVE
    from dbo.APPUSER
    where CUSTOM_AUTHENTICATION_USERID = @CUSTOM_AUTHENTICATION_USERID;

    return 0;
end;