USP_BBNC_GETCURRENCIESFORBATCHDOWNLOADBYACCOUNTIDFORUSERID

create procedure dbo.USP_BBNC_GETCURRENCIESFORBATCHDOWNLOADBYACCOUNTIDFORUSERID  
(  
  @ACCOUNTID uniqueidentifier,
  @BATCHID uniqueidentifier,
  @USERID uniqueidentifier
)  
as  
begin  
  declare @CURRENCYSETID uniqueidentifier  

  IF(@ACCOUNTID =  '00000000-0000-0000-0000-000000000000')
  BEGIN
     DECLARE @hDoc int, @rootxmlns varchar(100),@xmldata xml
    SET @rootxmlns = '<root xmlns:nsp="bb_appfx_commontypes"/>'
    SELECT @xmldata = BT.FORMDEFINITIONXML FROM BATCHTEMPLATE BT WHERE ID = @BATCHID
    EXEC sp_xml_preparedocument @hDoc OUTPUT, @xmldata, @rootxmlns  

    SELECT @ACCOUNTID = CAST(DefaultValueText AS UNIQUEIDENTIFIER)
    FROM OPENXML(@hDoc, '//nsp:FormMetaData/nsp:FormFields/nsp:FormField',1)
    WITH(FieldID nvarchar(100),DefaultValueText nvarchar(200))
    WHERE FieldID = 'PDACCOUNTSYSTEMID'

    --clean up 

    EXEC sp_xml_removedocument @hDoc

    IF(@ACCOUNTID IS NULL)
    BEGIN
        SET @ACCOUNTID = dbo.UFN_PDACCOUNTSYSTEM_GETDEFAULTSYSTEMIDSFORUSER(@USERID)
    END
  END

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

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