UFN_PDACCOUNT_GETCONSTITUENCY_2

            CREATE function [dbo].[UFN_PDACCOUNT_GETCONSTITUENCY_2]
            (
                @REVENUEID uniqueidentifier, 
                @REVENUESPLITID uniqueidentifier, 
                @INFORMATIONSOURCECODE tinyint, -- 0 revenue tables, 1 revenue batch tables

                @REVENUETRANSACTIONTYPECODE tinyint, 
                @REVENUESPLITTYPECODE tinyint, 
                @APPLICATIONCODE tinyint, 
                @PAYMENTMETHODCODE tinyint, 
                @DESIGNATIONID uniqueidentifier,
                @CURRENTAPPUSERID uniqueidentifier = null
            )
            returns uniqueidentifier
            As 
            begin
                declare @CONSTITID as uniqueidentifier;
                declare @RESULT as uniqueidentifier;

              if @INFORMATIONSOURCECODE = 0
                  select @CONSTITID = FINANCIALTRANSACTION.CONSTITUENTID
                  from dbo.FINANCIALTRANSACTION
                  where ID = @REVENUEID
              else
                select @CONSTITID = REVENUEINFORMATION.CONSTITUENTID 
                from dbo.UFN_REVENUEINFORMATION(@REVENUEID, @INFORMATIONSOURCECODE, @CURRENTAPPUSERID) as REVENUEINFORMATION;

                select top 1 @RESULT = V1.ID
                from (select distinct isnull(t2.ID, t3.ID) as ID, 
                                        t1.DESCRIPTION
                        from dbo.UFN_CONSTITUENT_GETALLCONSTITUENCIES(@CONSTITID) t1 
                            left join dbo.CONSTITUENCYCODE t2 
                                on t1.DESCRIPTION = t2.DESCRIPTION and t1.CONSTITUENCYTYPECODE = 99
                            left join dbo.CONSTITUENCYSYSTEMNAME t3 
                                on t1.DESCRIPTION = T3.DESCRIPTION and t1.CONSTITUENCYTYPECODE != 99) V1
                    left join dbo.PDCONSTITUENCYORDER t4 
                        on V1.ID = t4.CONSTITUENCYCODEID
                order by isnull(t4.SEQUENCE,99999), V1.DESCRIPTION;

                return @RESULT
            end