UFN_SITEID_MAPFROM_GRANTID

      CREATE function dbo.UFN_SITEID_MAPFROM_GRANTID  
      (  
        @GRANTSID uniqueidentifier  
      )   
        returns table
        as  
        return
        (
        select 
          CONSTITUENTSITE.SITEID
        from 
          dbo.GRANTS 
          inner join dbo.CONSTITUENT with (nolock) on CONSTITUENT.ID = GRANTS.GRANTORID
          left outer join dbo.CONSTITUENTSITE with (nolock) on CONSTITUENT.ID = CONSTITUENTSITE.CONSTITUENTID
        where 
          GRANTS.ID = @GRANTSID 
        )