UFN_REGISTRATIONPACKAGE_GETPRICESBASECURRENCYID

                create function dbo.UFN_REGISTRATIONPACKAGE_GETPRICESBASECURRENCYID
                (
                    @ID uniqueidentifier
                )
                returns uniqueidentifier
                with execute as caller
                as
                begin
                    declare @BASECURRENCYID uniqueidentifier;
                    set @BASECURRENCYID = 
                        (
                            select top 1
                                EVENT.BASECURRENCYID
                            from
                                dbo.REGISTRATIONPACKAGEPRICE
                                inner join dbo.EVENTPRICE on REGISTRATIONPACKAGEPRICE.EVENTPRICEID = EVENTPRICE.ID
                                inner join dbo.EVENT on EVENTPRICE.EVENTID = EVENT.ID
                            where
                                REGISTRATIONPACKAGEPRICE.REGISTRATIONPACKAGEID = @ID
                            order by
                                REGISTRATIONPACKAGEPRICE.DATEADDED
                        );
                    return @BASECURRENCYID;
                end