UFN_PLANNEDGIFTADDITION_GETASSETS

            CREATE function dbo.UFN_PLANNEDGIFTADDITION_GETASSETS(@PLANNEDGIFTADDITIONID uniqueidentifier)
            returns table
            as return
                select 
                    ID,
                    ASSETTYPECODEID,
                    DESCRIPTION,
                    VALUE,
                    COSTBASIS,
                    ASSETVALUATIONMETHODCODEID,
                    VALUATIONSOURCE,
                    ADDRESSID,
                    SEQUENCE,
                    dbo.UFN_PLANNEDGIFTADDITION_GETASSETHOLDERS_TOITEMLISTXML(ID) ASSETHOLDERS,
                    BASECURRENCYID,
                    ORGANIZATIONVALUE,
                    ORGANIZATIONCOSTBASIS,
                    ORGANIZATIONEXCHANGERATEID,
                    TRANSACTIONVALUE,
                    TRANSACTIONCOSTBASIS,
                    TRANSACTIONCURRENCYID,
                    BASEEXCHANGERATEID
                from
                    dbo.PLANNEDGIFTADDITIONASSET
                where
                    PLANNEDGIFTADDITIONID=@PLANNEDGIFTADDITIONID