APPS.JA_CN_GL_EAB_EXPORT_PKG SQL Statements

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

Line: 55

      SELECT jcspa.book_num,
             jcspa.book_name,
             jcspa.company_name,
             jcspa.organization_id,
             jcspa.ent_quality,
             jcspa.ent_industry,
             ar.major_version || '.' || ar.minor_version || '.' ||
             ar.tape_version software_version,
             fcv.name,
             jcspa.cnao_stand_ver
        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 = ln_ledger_id
         AND jcspa.legal_entity_id = ln_legal_entity_id;