DBA Data[Home] [Help]

APPS.JA_CN_SI_BANK_DET_PKG dependencies on AD_RELEASES

Line 72: ad_releases ar,

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

Line 74: WHERE ar.release_id = (SELECT max(release_id) FROM ad_releases)

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;