APPS.JA_CN_FA_DM_EXPORT_PKG SQL Statements

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

Line: 55

SELECT
  method_code
, method_name
, depreciation_formula
FROM
  ja_cn_dep_meth_assignment
WHERE
  legal_entity_id = pn_legal_entity_id
AND
 (effective_date_to IS NULL
OR
 TRUNC(effective_date_to) >= TRUNC(TO_DATE(pv_accounting_year || '0101','YYYYMMDD')));