UFN_SITEID_MAPFROM_GRANTDEADLINEID

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