UFN_CONSTITUENTID_MAPFROM_STEWARDSHIPPLANID

            CREATE function dbo.UFN_CONSTITUENTID_MAPFROM_STEWARDSHIPPLANID(@STEWARDSHIPPLANID uniqueidentifier) 
            returns uniqueidentifier
            as
            begin
                --JamesWill WI106974 2010-07-09 Update the mappings now that constituents can have multiple plans

                declare @R uniqueidentifier = null;
                select top 1 @R = CONSTITUENTID from dbo.STEWARDSHIPPLAN where STEWARDSHIPPLAN.ID = @STEWARDSHIPPLANID;
                return @R;
            end