68: fcv.name,
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
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
78: AND jcspa.flex_segment_value = lv_bsv;