UFN_PROSPECTUSER_CANGET_WEATHUPDATE

create function dbo.UFN_PROSPECTUSER_CANGET_WEATHUPDATE
(
  @APPUSERID uniqueidentifier,
  @BUSINESSPROCESSID uniqueidentifier
)
returns bit
  as begin
    declare @CANGETWEALTHUPDATE bit;
    declare @WEALTHPOINTREGISTERED bit; 
    declare @ISADMIN bit;

      set @CANGETWEALTHUPDATE = 0;    
    set @ISADMIN = dbo.UFN_APPUSER_ISSYSADMIN(@APPUSERID);

    select top (1)
                    @WEALTHPOINTREGISTERED =  REGISTERED
        from
                    dbo.WEALTHPOINTCONFIGURATION

    --If Regitered

    if (@WEALTHPOINTREGISTERED = 1)
      if (@ISADMIN <> 1) -- Not Admin then check permissions on businessprocess

        set  @CANGETWEALTHUPDATE = dbo.UFN_SECURITY_APPUSER_GRANTED_BUSINESSPROCESS_IN_SYSTEMROLE(@APPUSERID,@BUSINESSPROCESSID)
      else
        set  @CANGETWEALTHUPDATE = 1
    return @CANGETWEALTHUPDATE
end