USP_DATALIST_POSTTOGLPROCESS

                CREATE procedure dbo.USP_DATALIST_POSTTOGLPROCESS(@CURRENTAPPUSERID uniqueidentifier = null, @SHOWINACTIVE bit = 0)
                as 
                    set nocount on;
          declare @POSTTOGLPROCESSID uniqueidentifier
          declare @BASICGL bit
          declare @ISADMIN bit

          set @ISADMIN = dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID)


          --kwb Bug 56202 Should only see post processes that are valid for the current product flags

          --if BasicGL is installed, use the treasury post process.  Otherwise, legacy post process

          -- Updated with Account Security for Basic GL.  bug 97777

          set @BASICGL = dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('0E85C527-E6E9-4C5F-A8E8-105FD0E18FE7')
          if @BASICGL = 1
            set @POSTTOGLPROCESSID = 'b4acd31d-d511-465e-89f1-733cded5f975'
          else
            set @POSTTOGLPROCESSID = '48EF5B33-14CC-41cd-96BF-29F490B0A60F'

                    select 
                        POSTTOGLPROCESS.ID, 
                        POSTTOGLPROCESS.NAME, 
                        POSTTOGLPROCESS.DESCRIPTION,
                        MARKASPOSTED,                
                        POSTTOGLPROCESS.POSTINGOPTION,
                        IDSET.NAME as IDSET,
                        dbo.UFN_BUSINESSPROCESSVIEW_GETNAME(BUSINESSPROCESSVIEWID),
                        BPI.OWNERID as OWNERID,
                        POSTTOGLPROCESS.DEPOSITPOSTINGOPTION,
                        DEPOSITIDSET.NAME as DEPOSITIDSET,
                        POSTTOGLPROCESS.ADJUSTMENTPOSTINGOPTION,
                        ADJUSTMENTIDSET.NAME as ADJUSTMENTIDSET,
                        case when POSTTOGLPROCESS.ISACTIVE = 1 then 'Active' else 'Inactive' end as [ACTIVESTATE],
                        POSTTOGLPROCESS.ISACTIVE,
                        ACCTSYS.NAME as SYSTEMNAME
                    from 
                        dbo.POSTTOGLPROCESS
                    left join dbo.IDSETREGISTER as IDSET on POSTTOGLPROCESS.IDSETREGISTERID = IDSET.ID
                    left join dbo.IDSETREGISTER as DEPOSITIDSET on POSTTOGLPROCESS.DEPOSITIDSETREGISTERID = DEPOSITIDSET.ID
                    left join dbo.IDSETREGISTER as ADJUSTMENTIDSET on POSTTOGLPROCESS.ADJUSTMENTIDSETREGISTERID = ADJUSTMENTIDSET.ID
                    left join dbo.BUSINESSPROCESSINSTANCE BPI on POSTTOGLPROCESS.ID = BPI.BUSINESSPROCESSPARAMETERSETID
                    left join dbo.PDACCOUNTSYSTEM as ACCTSYS on POSTTOGLPROCESS.PDACCOUNTSYSTEMID = ACCTSYS.ID
                    where (dbo.UFN_SECURITY_APPUSER_GRANTED_BUSINESSPROCESSINSTANCE_IN_SYSTEMROLE(@CURRENTAPPUSERID, POSTTOGLPROCESS.ID) = 1)
                        and BPI.BUSINESSPROCESSCATALOGID = @POSTTOGLPROCESSID
                        and (@SHOWINACTIVE = 1 or POSTTOGLPROCESS.ISACTIVE = 1)
                        and (@ISADMIN=1 or @BASICGL=0 or (ACCTSYS.ID in (select T1.ID from dbo.UFN_PDACCOUNTSYSTEM_GETSYSTEMIDSFORUSER(@CURRENTAPPUSERID) T1)))

                    order by
                        POSTTOGLPROCESS.DATEADDED;