USP_SIMPLEDATALIST_BANKACCOUNTAUTHORIZEDSIGNATURE

CREATE procedure dbo.USP_SIMPLEDATALIST_BANKACCOUNTAUTHORIZEDSIGNATURE
(
  @BANKACCOUNTID uniqueidentifier = null
)as
    select 
        B.ID as VALUE, 
        dbo.UFN_SIGNATURE_USERNAME(S.SIGNERCODE, S.NAME, S.APPUSERID) as LABEL
    from dbo.BANKACCOUNTAUTHORIZEDSIGNATURE B
  inner join dbo.SIGNATURE S on S.ID = B.SIGNATUREID
  where B.BANKACCOUNTID = @BANKACCOUNTID and B.AUTOSIGNATURECODE = 1
    order by S.NAME