USP_DATALIST_STANDINGORDERSIMPORTPROCESS

CREATE procedure dbo.USP_DATALIST_STANDINGORDERSIMPORTPROCESS
(
    @CURRENTAPPUSERID uniqueidentifier = null
)
as
set nocount on;

declare @BASICGL bit
set @BASICGL = dbo.UFN_VALID_BASICGL_INSTALLED()

select
  [PROCESS].ID,
  [PROCESS].NAME,
  [PROCESS].DESCRIPTION,
  [BATCH].NAME as BATCHDESIGN,
  [PROCESS].BATCHNUMBER,
  [PROCESS].IMPORTFILENAME,
  [TEMPLATE].NAME IMPORTTEMPLATE,
  BPI.OWNERID as OWNERID,
  [ACCTSYS].NAME as ACCOUNTSYSTEM
from dbo.STANDINGORDERSIMPORTPROCESS as [PROCESS]
inner join dbo.BATCHTEMPLATE as [BATCH] on [BATCH].ID = [PROCESS].BATCHTEMPLATEID
left join dbo.BUSINESSPROCESSINSTANCE BPI on [PROCESS].ID = BPI.BUSINESSPROCESSPARAMETERSETID
left join dbo.STANDINGORDERSIMPORTTEMPLATE as [TEMPLATE] on [PROCESS].IMPORTTEMPLATEID = [TEMPLATE].ID
left join dbo.PDACCOUNTSYSTEM as [ACCTSYS] on [PROCESS].PDACCOUNTSYSTEMID=[ACCTSYS].ID 
where (dbo.UFN_SECURITY_APPUSER_GRANTED_BUSINESSPROCESSINSTANCE_IN_SYSTEMROLE(@CURRENTAPPUSERID, [PROCESS].ID) = 1)
 and (@BASICGL=0 or [PROCESS].PDACCOUNTSYSTEMID in (select ID from dbo.UFN_PDACCOUNTSYSTEM_GETSYSTEMIDSFORUSER(@CurrentAppUserID)))
order by [PROCESS].NAME;