UFN_PLANNEDGIFTADDITION_GETASSETHOLDERS

Returns the holders of a planned gift addition asset.

Return

Return Type
table

Parameters

Parameter Parameter Type Mode Description
@PLANNEDGIFTADDITIONASSETID uniqueidentifier IN

Definition

Copy


          create function dbo.UFN_PLANNEDGIFTADDITION_GETASSETHOLDERS
          (
              @PLANNEDGIFTADDITIONASSETID uniqueidentifier
          )
            returns table
            as return
              select 
                  ID,
                  HOLDERCONSTITUENTID
              from
                  dbo.PLANNEDGIFTADDITIONASSETHOLDER
              where
                  PLANNEDGIFTADDITIONASSETID = @PLANNEDGIFTADDITIONASSETID