USP_BBNC_GIFTSPLITDATA

            CREATE procedure dbo.USP_BBNC_GIFTSPLITDATA(@ID int)
            as
            set nocount on;

            select
                dbo.UFN_BBNC_GETDESIGNATIONMAPID(DESIGNATION.ID) as [MAPID],
                REVENUESPLIT.AMOUNT,
                case
                    when DESIGNATION.VANITYNAME is null or len(DESIGNATION.VANITYNAME) = 0 then DESIGNATION.NAME
                    else DESIGNATION.VANITYNAME
                end as [DESCRIPTION],
                DESIGNATION.USERID as [LOOKUPID]
            from 
                dbo.REVENUESPLIT
                inner join dbo.BBNCREVENUESPLITIDMAP on BBNCREVENUESPLITIDMAP.REVENUESPLITID = REVENUESPLIT.ID 
                inner join dbo.DESIGNATION on DESIGNATION.ID = REVENUESPLIT.DESIGNATIONID
            where
                BBNCREVENUESPLITIDMAP.ID = @ID