UFN_PROSPECTPLAN_USERHASSITEACCESS

      CREATE function dbo.UFN_PROSPECTPLAN_USERHASSITEACCESS
      (
        @APPUSERID uniqueidentifier,
        @PROSPECTPLANID uniqueidentifier
      )
      returns bit with execute as caller
      as 
      begin
        if exists
        (
          select SITEID 
          from 
            (
              select SITE.ID as [SITEID]
              from dbo.PROSPECTPLANSITE
              left join dbo.SITE on SITE.ID = PROSPECTPLANSITE.SITEID
              where PROSPECTPLANSITE.PROSPECTPLANID = @PROSPECTPLANID
            ) as [PROSPECTPLANSITES]
          where dbo.UFN_SITEALLOWEDFORUSER(@APPUSERID, [PROSPECTPLANSITES].SITEID) = 1
        )
          return 1;
        else
          if (select count(ID) from dbo.PROSPECTPLANSITE where PROSPECTPLANID = @PROSPECTPLANID) = 0
              return dbo.UFN_SITEALLOWEDFORUSER(@APPUSERID, null);
          else
            return 0;
        return 0;
      end