DBA Data[Home] [Help]

APPS.JA_CN_ACP_EXPORT_PKG SQL Statements

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

Line: 57

      SELECT gp.period_year, gp.period_num, gp.start_date, gp.end_date
        FROM gl_periods gp, gl_ledgers gl
       WHERE gp.period_year = ln_accounting_year
         AND gp.period_set_name = gl.period_set_name
         -- choli fix bug 12639817
         AND gp.period_type = gl.accounted_period_type
         AND gl.ledger_id = ln_ledger_id;