APPS.JA_CN_SI_BANK_DET_PKG dependencies on FND_CURRENCIES_VL

Line 73: fnd_currencies_vl fcv

69: jcspa.cnao_stand_ver
70: FROM JA_CN_SYSTEM_BANK_PARAMS_ALL_V jcspa,
71: gl_ledgers gl,
72: ad_releases ar,
73: fnd_currencies_vl fcv
74: WHERE ar.release_id = (SELECT max(release_id) FROM ad_releases)
75: AND fcv.currency_code = gl.currency_code
76: AND gl.ledger_id = ln_ledger_id
77: AND jcspa.legal_entity_id = ln_legal_entity_id

Line 613: FROM fnd_currencies_vl fcv, GL_JE_LINES gjl, GL_JE_HEADERS gjh

609: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
610: -- to get Currencies
611: CURSOR CUR_Currency IS
612: SELECT fcv.currency_code, fcv.name currency_name
613: FROM fnd_currencies_vl fcv, GL_JE_LINES gjl, GL_JE_HEADERS gjh
614: WHERE fcv.currency_code = gjh.CURRENCY_CODE
615: AND gjh.je_header_id = gjl.je_header_id
616: AND gjh.ledger_id = pn_ledger_id
617: AND gjh.period_name IN