UFN_BUSINESSPROCESSSTATUS_CURRENTLYRUNORENQUEUEDBY

      create function [dbo].[UFN_BUSINESSPROCESSSTATUS_CURRENTLYRUNORENQUEUEDBY]
      (
        @BUSINESSPROCESSCATALOGID uniqueidentifier,
        @PARAMETERSETID uniqueidentifier
      )
      returns nvarchar(255)
      with execute as caller
      as
      begin
        declare @USERNAME nvarchar(255) = '';

        select 
          @USERNAME = [STARTEDBY].[USERNAME]
        from 
          dbo.[BUSINESSPROCESSSTATUS]
          inner join dbo.[APPUSER] as [STARTEDBY] on [STARTEDBY].[ID] = [BUSINESSPROCESSSTATUS].[STARTEDBYUSERID]
        where 
          [BUSINESSPROCESSSTATUS].[BUSINESSPROCESSCATALOGID] = @BUSINESSPROCESSCATALOGID and 
          [BUSINESSPROCESSSTATUS].[BUSINESSPROCESSPARAMETERSETID] = @PARAMETERSETID and 
          [BUSINESSPROCESSSTATUS].[STATUSCODE] in (1, 4);

        return @USERNAME;
      end