USP_STANDINGORDERSIMPORTPROCESS_GETBYID

CREATE procedure dbo.USP_STANDINGORDERSIMPORTPROCESS_GETBYID
(
    @ID uniqueidentifier,
    @CURRENTAPPUSERID uniqueidentifier = null
)
with execute as caller
as
  set nocount on;
    declare @SHOWACCOUNTSYSTEM bit;
    set @SHOWACCOUNTSYSTEM = 0;

    if dbo.UFN_VALID_BASICGL_INSTALLED() != 0 and dbo.UFN_PDACCOUNTSYSTEM_GETNUMBEROFSYSTEMSFORUSER(@CURRENTAPPUSERID) > 1
      set @SHOWACCOUNTSYSTEM = 1;        

    select
        NAME,
        DESCRIPTION,
        BATCHTEMPLATEID,
        BATCHNUMBER,
        OWNERID,
        IMPORTFILENAME,
        IMPORTTEMPLATEID,
        DUEDATETYPECODE,
        CUTOFFDATE,
        DAYSAFTER,
        PAYFUTURE,
        PDACCOUNTSYSTEMID,
        @SHOWACCOUNTSYSTEM as SHOWACCOUNTSYSTEM
    from
        dbo.STANDINGORDERSIMPORTPROCESS
    where 
        ID = @ID;