UFN_CONSTITUENT_MAPFROM_WRITEOFFID

            create function dbo.UFN_CONSTITUENT_MAPFROM_WRITEOFFID
            (
                @WRITEOFFID uniqueidentifier
            )
            returns uniqueidentifier
            as
            begin
                declare @CONSTITUENTID uniqueidentifier;

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

                return @CONSTITUENTID;
            end