APPS.JA_CN_SI_BANK_DET_PKG dependencies on JA_CN_SYSTEM_BANK_PARAMS_ALL

Line 70: FROM JA_CN_SYSTEM_BANK_PARAMS_ALL_V jcspa,

66: ar.major_version || '.' || ar.minor_version || '.' ||
67: ar.tape_version software_version,
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)

Line 774: from ja_cn_system_bank_params_all jcs

770: pv_bsv VARCHAR2,
771: pn_accounting_year NUMBER) IS
772: CURSOR CUR_CODE IS
773: select accounting_struct_id, ACCOUNTING_STRUCTURE_FLEX_NUM
774: from ja_cn_system_bank_params_all jcs
775: WHERE jcs.ledger_id = pn_ledger_id --jcs.flex_vale_segment=pv_bsv
776: AND rownum=1
777: ORDER BY flex_segment_value;
778: l_code cur_code%rowtype;