UFN_ID_MAPFROM_WPNONPROFITAFFILIATIONID

            create function dbo.UFN_ID_MAPFROM_WPNONPROFITAFFILIATIONID(@WPNONPROFITAFFILIATIONID uniqueidentifier) 
            returns uniqueidentifier
            as
            begin
                declare @ID uniqueidentifier;

                select @ID = WEALTH.ID from dbo.WPNONPROFITAFFILIATION
                inner join dbo.WEALTH on WEALTH.ID = WPNONPROFITAFFILIATION.WEALTHID
                where WPNONPROFITAFFILIATION.ID = @WPNONPROFITAFFILIATIONID;

                return @ID;
            end