USP_DATALIST_GENERATEBACSFILEPROCESS

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

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

    select
    GENERATEBACSFILEPROCESS.ID,
    GENERATEBACSFILEPROCESS.NAME,
    GENERATEBACSFILEPROCESS.DESCRIPTION,
    case GENERATEBACSFILEPROCESS.DATETYPECODE
        when 0 then getdate() 
        when 2 then dateadd(day,GENERATEBACSFILEPROCESS.FINDAYSAFTER,getdate()) 
        else GENERATEBACSFILEPROCESS.DATE end,
    BPI.OWNERID as OWNERID,
     BA.ACCOUNTNAME as BANKACCOUNT
from
    dbo.GENERATEBACSFILEPROCESS
left join dbo.BUSINESSPROCESSINSTANCE BPI on GENERATEBACSFILEPROCESS.ID = BPI.BUSINESSPROCESSPARAMETERSETID
left join dbo.BANKACCOUNT BA on GENERATEBACSFILEPROCESS.BANKACCOUNTID = BA.ID            
where (dbo.UFN_SECURITY_APPUSER_GRANTED_BUSINESSPROCESSINSTANCE_IN_SYSTEMROLE(@CURRENTAPPUSERID, GENERATEBACSFILEPROCESS.ID) = 1)
  and (@BASICGL=0 or BA.PDACCOUNTSYSTEMID in (select ID from dbo.UFN_PDACCOUNTSYSTEM_GETSYSTEMIDSFORUSER(@CurrentAppUserID)))
order by
    GENERATEBACSFILEPROCESS.NAME;