UFN_MKTRECORDSOURCE_VALIDFORBBEC

CREATE function dbo.[UFN_MKTRECORDSOURCE_VALIDFORBBEC]
(
  @RECORDSOURCEID uniqueidentifier
)
returns bit
as
begin
  return (case when
                 dbo.[UFN_MKTRECORDSOURCE_VALIDFORPRODUCT](@RECORDSOURCEID) = 1
                 and [dbo].[UFN_INSTALLEDPRODUCTS_PRODUCTIS]('BB9873D7-F1ED-430A-8AB4-F09F47056538') = 0
               then 
                 case when (select [RECORDTYPE].[NAME]
                            from dbo.[RECORDTYPE]
                            inner join dbo.[QUERYVIEWCATALOG] on [QUERYVIEWCATALOG].[RECORDTYPEID] = [RECORDTYPE].[ID]
                            where [QUERYVIEWCATALOG].[ID] = @RECORDSOURCEID) = 'Constituent'
                      then 1
                      else 0
                 end
               else 0
          end);
end