UFN_SITEID_MAPFROM_INTERACTIONMEDIALINKID

            CREATE function dbo.UFN_SITEID_MAPFROM_INTERACTIONMEDIALINKID(@INTERACTIONMEDIALINKID uniqueidentifier)    
            returns table
            as  
            return 
                select coalesce(PROSPECTPLANSITE.SITEID,FUNDINGPLAN.SITEID,INTERACTIONSITE.SITEID) SITEID
                from dbo.INTERACTIONMEDIALINK
                    inner join dbo.INTERACTION on INTERACTION.ID = INTERACTIONMEDIALINK.INTERACTIONID
                    left outer join dbo.PROSPECTPLANSITE on INTERACTION.PROSPECTPLANID = PROSPECTPLANSITE.PROSPECTPLANID  
                    left outer join dbo.INTERACTIONSITE on INTERACTIONSITE.INTERACTIONID = INTERACTION.ID and dbo.UFN_INTERACTION_ISPLANSTEP(INTERACTION.ID) = 0
                    left outer join dbo.FUNDINGREQUEST on FUNDINGREQUEST.ID = INTERACTION.FUNDINGREQUESTID
                    left outer join dbo.FUNDINGPLAN on FUNDINGPLAN.ID = FUNDINGREQUEST.FUNDINGPLANID
                where INTERACTIONMEDIALINK.ID = @INTERACTIONMEDIALINKID;