58: -- to get Currencies
59: CURSOR Currencies_cur(ln_legal_entity_id NUMBER,
60: ln_accounting_year NUMBER) IS
61: SELECT DISTINCT fcv.currency_code, fcv.name
62: FROM fnd_currencies_vl fcv,
63: ja_cn_journal_lines jcjl,
64: ja_cn_voucher_number jcvn
65: --Update by Jianchao Chi, for cnaov2 upgrade 05-JAN-2011
66: --Add ja_cn_voucher_number table, voucher number and legal entity