USP_DATALIST_PLANNEDGIFT_RELATIONSHIPS

                CREATE procedure dbo.USP_DATALIST_PLANNEDGIFT_RELATIONSHIPS(@PLANNEDGIFTID uniqueidentifier)
                as
                    set nocount on;

                    select 
                        PGR.ID,
                        R.ID,
                        NF.NAME,
                        R.RECIPROCALCONSTITUENTID,
                        RT.DESCRIPTION,
            R.ISPRIMARYBUSINESS as PRIMARYBUSINESS,
            RJ.JOBTITLE 
                    from
                        dbo.PLANNEDGIFTRELATIONSHIP PGR
                        inner join dbo.RELATIONSHIP R on R.ID=PGR.RELATIONSHIPID
                        left join dbo.RELATIONSHIPJOBINFO RJ on RJ.RELATIONSHIPSETID = R.RELATIONSHIPSETID
                        outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(R.RECIPROCALCONSTITUENTID) NF
                        left outer join dbo.RELATIONSHIPTYPECODE RT on RT.ID=R.RECIPROCALTYPECODEID
                        left outer join (
                            select 
                                C_BUSINESS.NAME, 
                                R_BUSINESS.POSITION, 
                                R_BUSINESS.RELATIONSHIPCONSTITUENTID
                            from 
                                dbo.RELATIONSHIP R_BUSINESS
                                inner join dbo.CONSTITUENT C_BUSINESS on C_BUSINESS.ID=R_BUSINESS.RECIPROCALCONSTITUENTID
                            where
                                R_BUSINESS.ISPRIMARYBUSINESS=1
                                and C_BUSINESS.ISORGANIZATION=1
                        ) BUSINESS on BUSINESS.RELATIONSHIPCONSTITUENTID=R.RECIPROCALCONSTITUENTID
                    where
                        PGR.PLANNEDGIFTID=@PLANNEDGIFTID
                    order by
                        PGR.SEQUENCE;