USP_BBNC_GETCURRENCIESBYACCOUNTID

CREATE procedure dbo.USP_BBNC_GETCURRENCIESBYACCOUNTID
(
  @ACCOUNTID uniqueidentifier
)
as
begin
  declare @CURRENCYSETID uniqueidentifier

  select @CURRENCYSETID = CURRENCYSETID
  from dbo.PDACCOUNTSYSTEM
  where ID = @ACCOUNTID

  select 
    ID,
    CURRENCYID,
    SEQUENCE
  from 
    dbo.UFN_CURRENCYSET_GETTRANSACTIONCURRENCIES(@CURRENCYSETID)
end