UFN_CONSTITUENT_MAPFROM_RECURRINGGIFTWRITEOFF

create function dbo.UFN_CONSTITUENT_MAPFROM_RECURRINGGIFTWRITEOFF(
    @RECURRINGGIFTWRITEOFFID uniqueidentifier
)
returns uniqueidentifier
with execute as caller
as begin
    declare @CONSTITUENTID uniqueidentifier;

    select top 1 
        @CONSTITUENTID = REVENUE.CONSTITUENTID
    from dbo.REVENUE
    inner join dbo.RECURRINGGIFTWRITEOFF on RECURRINGGIFTWRITEOFF.REVENUEID = REVENUE.ID
    where RECURRINGGIFTWRITEOFF.ID = @RECURRINGGIFTWRITEOFFID;

    return @CONSTITUENTID;
end