UFN_PLANNEDGIFT_ASSETHOLDERS

Returns the holders of a planned gift asset.

Return

Return Type
table

Parameters

Parameter Parameter Type Mode Description
@PLANNEDGIFTASSETID uniqueidentifier IN

Definition

Copy

            create function dbo.UFN_PLANNEDGIFT_ASSETHOLDERS
            (
                @PLANNEDGIFTASSETID uniqueidentifier
            )
            returns table
            as return
                select 
                    ID,
                    HOLDERCONSTITUENTID
                from
                    dbo.PLANNEDGIFTASSETHOLDER
                where
                    PLANNEDGIFTASSETID = @PLANNEDGIFTASSETID