UFN_PLANNEDGIFT_GETORDEREDBENEFICIARIES

            CREATE function dbo.UFN_PLANNEDGIFT_GETORDEREDBENEFICIARIES
            (
                @PLANNEDGIFTID uniqueidentifier
            )
            returns table
            as
            return 
                select 
                    row_number() over (order by CONSTITUENT.AGE ASC) as ROWNUMBER,
                    NF.NAME as BENEFICIARYNAME,
                    CONSTITUENT.AGE as BENEFICIARYAGE,
                    PLANNEDGIFTBENEFICIARY.PRIORITYCODE as BENEFICIARYDEPENDENCY,
                    dbo.UFN_BENEFICIARYTYPECODE_GETDESCRIPTION(PLANNEDGIFTBENEFICIARY.BENEFICIARYTYPECODEID) as BENEFICIARYTYPE
                from
                    dbo.PLANNEDGIFTBENEFICIARY
                inner join 
                    dbo.PLANNEDGIFT on PLANNEDGIFT.ID = PLANNEDGIFTBENEFICIARY.PLANNEDGIFTID
                inner join 
                    dbo.CONSTITUENT on CONSTITUENT.ID = PLANNEDGIFTBENEFICIARY.BENEFICIARYCONSTITUENTID
                outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(CONSTITUENT.ID) NF
                where
                    PLANNEDGIFTBENEFICIARY.PLANNEDGIFTID = @PLANNEDGIFTID