UFN_CONSTITID_MAPFROM_REVENUETRIBUTEID

            create function dbo.UFN_CONSTITID_MAPFROM_REVENUETRIBUTEID
            (
                @REVENUETRIBUTEID uniqueidentifier
            )
            returns uniqueidentifier
            as
            begin
                declare @ID uniqueidentifier

                select @ID = REVENUE.CONSTITUENTID
                from dbo.REVENUETRIBUTE
                inner join dbo.REVENUE on REVENUETRIBUTE.REVENUEID = REVENUE.ID
                where REVENUETRIBUTE.ID = @REVENUETRIBUTEID

                return @ID
            end