USP_DATALIST_PLANNEDGIFTADDITION_DESIGNATION

              CREATE procedure dbo.USP_DATALIST_PLANNEDGIFTADDITION_DESIGNATION(@PLANNEDGIFTADDITIONID uniqueidentifier)
              as
                  select 
                      PLANNEDGIFTADDITIONDESIGNATION.ID,
                      DESIGNATION.ID,
                      case when len(DESIGNATION.VANITYNAME) > 0 then
                          DESIGNATION.VANITYNAME
                      else
                          DESIGNATION.NAME
                      end,
                      PLANNEDGIFTADDITIONDESIGNATION.TRANSACTIONAMOUNT,
                      dbo.UFN_PLANNEDGIFTDESCATEGORYCODE_GETDESCRIPTION(PLANNEDGIFTADDITIONDESIGNATION.CATEGORYCODEID) as CATEGORY,
                      dbo.UFN_OPPORTUNITYDESIGNATIONTYPECODE_GETDESCRIPTION(PLANNEDGIFTADDITIONDESIGNATION.TYPECODEID) as TYPE,
                      dbo.UFN_DESIGNATIONUSECODE_GETDESCRIPTION(PLANNEDGIFTADDITIONDESIGNATION.USECODEID) as USECODE,
                      PLANNEDGIFTADDITIONDESIGNATION.DATE,
                      PLANNEDGIFTADDITIONDESIGNATION.TRANSACTIONCURRENCYID,
                      PLANNEDGIFTADDITIONDESIGNATION.AMOUNT as BASEAMOUNT,
                      PLANNEDGIFTADDITIONDESIGNATION.BASECURRENCYID
                  from
                      dbo.PLANNEDGIFTADDITIONDESIGNATION
                      left join dbo.DESIGNATION on DESIGNATION.ID = PLANNEDGIFTADDITIONDESIGNATION.DESIGNATIONID 
                  where
                      PLANNEDGIFTADDITIONDESIGNATION.PLANNEDGIFTADDITIONID=@PLANNEDGIFTADDITIONID
                  order by
                      PLANNEDGIFTADDITIONDESIGNATION.SEQUENCE;