UFN_MKTSEGMENTATION_ISREFRESHING

CREATE function dbo.[UFN_MKTSEGMENTATION_ISREFRESHING]
(
  @SEGMENTATIONID uniqueidentifier
)
returns bit
as
begin
  return
  (
    select (case when [MKTSEGMENTATION].[ACTIVE] = 0 and exists (
               select 1
               from dbo.[MKTSEGMENTATIONREFRESHPROCESSSTATUS]
               inner join dbo.[BUSINESSPROCESSSTATUS] on [BUSINESSPROCESSSTATUS].[ID] = [MKTSEGMENTATIONREFRESHPROCESSSTATUS].[ID]
               where [BUSINESSPROCESSSTATUS].[BUSINESSPROCESSCATALOGID] = 'F49185FF-9F54-43EA-B798-8C13E659CD8F'
               and [MKTSEGMENTATIONREFRESHPROCESSSTATUS].[PARAMETERSETID] = [MKTSEGMENTATIONREFRESHPROCESS].[ID]
               and [BUSINESSPROCESSSTATUS].[STATUSCODE] = 1)
            then 1 else 0 end)
    from dbo.[MKTSEGMENTATION]
    inner join dbo.[MKTSEGMENTATIONREFRESHPROCESS] 
        on [MKTSEGMENTATIONREFRESHPROCESS].[SEGMENTATIONID] = [MKTSEGMENTATION].[ID]
    where [MKTSEGMENTATION].[ID] = @SEGMENTATIONID
  );
end