USP_DATALIST_GLACCOUNTSEQUENCE

CREATE procedure dbo.USP_DATALIST_GLACCOUNTSEQUENCE
as
    set nocount on;

  declare @PDACCOUNTSYSTEMID uniqueidentifier = '4B121C2C-CCE6-440D-894C-EA0DEF80D50B';

    select ID,
    DESCRIPTION
    from dbo.PDACCOUNTSTRUCTURE
    where elementtypecode = 1 and PDACCOUNTSYSTEMID = @PDACCOUNTSYSTEMID and ISBASICGL = 0
  order by SEGMENTSEQUENCE