UFN_MKTSEGMENTATION_ISACTIVATING

      CREATE function dbo.[UFN_MKTSEGMENTATION_ISACTIVATING]
      (
        @SEGMENTATIONID uniqueidentifier
      )
      returns bit
      as
      begin
        return
        (
          select (case when [MKTSEGMENTATION].[ACTIVE] = 0 and exists(
                     select 1
                     from dbo.[MKTSEGMENTATIONACTIVATEPROCESSSTATUS]
                     inner join dbo.[BUSINESSPROCESSSTATUS] on [BUSINESSPROCESSSTATUS].[ID] = [MKTSEGMENTATIONACTIVATEPROCESSSTATUS].[ID]
                     where [BUSINESSPROCESSSTATUS].[BUSINESSPROCESSCATALOGID] = '22C3D75C-A956-4BFC-A5FD-4B866BAEF509'
                     and [MKTSEGMENTATIONACTIVATEPROCESSSTATUS].[PARAMETERSETID] = [MKTSEGMENTATIONACTIVATEPROCESS].[ID]
                     and [BUSINESSPROCESSSTATUS].[STATUSCODE] = 1)
                  then 1 else 0 end)
          from dbo.[MKTSEGMENTATION]
          inner join dbo.[MKTSEGMENTATIONACTIVATEPROCESS] on [MKTSEGMENTATIONACTIVATEPROCESS].[SEGMENTATIONID] = [MKTSEGMENTATION].[ID]
          where [MKTSEGMENTATION].[ID] = @SEGMENTATIONID
        );
      end