APPS.JA_CN_PS_SI_EAB_EXPORT_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 61

SELECT
  jcspa.book_num
, jcspa.book_name
, jcspa.company_name
, jcspa.organization_id
, jcspa.ent_quality
, jcspa.ent_industry
, jcspa.admin_division_code
, jcspa.budget_mgmt_level
, jcspa.fund_source
, jcspa.cnao_stand_ver
, ar.major_version || '.' || ar.minor_version || '.'
    || ar.tape_version software_version
, fcv.NAME
FROM
  ja_cn_system_parameters_all jcspa
, gl_ledgers                  gl
, ad_releases                 ar
, fnd_currencies_vl           fcv
WHERE ar.release_id = (SELECT MAX(release_id) FROM ad_releases)
  AND fcv.currency_code = gl.currency_code
  AND gl.ledger_id = pn_ledger
  AND jcspa.legal_entity_id = pn_legal_entity;