USP_DATALIST_PLANNEDGIFT_BENEFICIARIES

                CREATE procedure dbo.USP_DATALIST_PLANNEDGIFT_BENEFICIARIES
                (
                    @PLANNEDGIFTID uniqueidentifier
                )
                as
                    select 
                        PGB.ID,
                        C.ID,
                        NF.NAME,
                        case when DC.ID is not null
              then
                0
              else
                case C.BIRTHDATE when '00000000'
                  then
                    null
                  else
                    C.AGE
                end
            end,
                        PGB.PRIORITY,
                        BT.DESCRIPTION
                    from
                        dbo.PLANNEDGIFTBENEFICIARY PGB
                    inner join 
                        dbo.CONSTITUENT C on C.ID=PGB.BENEFICIARYCONSTITUENTID
                    outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(C.ID) NF
                    left outer join 
                        dbo.BENEFICIARYTYPECODE BT on BT.ID=PGB.BENEFICIARYTYPECODEID
            left outer join
                        dbo.DECEASEDCONSTITUENT DC on DC.ID = C.ID
                    where
                        PGB.PLANNEDGIFTID=@PLANNEDGIFTID
                    order by
                        PGB.SEQUENCE;