APPS.JA_CN_FA_EXPORT_PROG SQL Statements

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

Line: 374

      SELECT PERIOD_NAME
        INTO lv_period_from
        FROM (SELECT PERIOD_NAME
                FROM GL_PERIOD_STATUSES
               WHERE APPLICATION_ID = 101
                 AND LEDGER_ID = pn_ledger_id
                 AND PERIOD_YEAR = pv_accounting_year
                 AND CLOSING_STATUS <> 'N'
                 AND CLOSING_STATUS <> 'F'
               ORDER BY START_DATE)
       WHERE ROWNUM = 1;

Line: 396

      SELECT PERIOD_NAME
        INTO lv_period_to
        FROM (SELECT PERIOD_NAME
                FROM GL_PERIOD_STATUSES
               WHERE APPLICATION_ID = 101
                 AND LEDGER_ID = pn_ledger_id
                 AND PERIOD_YEAR = pv_accounting_year
                 AND CLOSING_STATUS <> 'N'
                 AND CLOSING_STATUS <> 'F'
               ORDER BY START_DATE DESC)
       WHERE ROWNUM = 1;

Line: 445

      SELECT
        lookup_code
      INTO
        lv_gle_req_status_code
      FROM
        fnd_lookup_values
      WHERE lookup_type = 'CP_STATUS_CODE'
        AND view_application_id=0
        AND security_group_id=0
        AND meaning=lv_gle_req_status
        AND enabled_flag='Y'
        AND language = USERENV('LANG');

Line: 608

   SELECT context_code, attribute_column
     FROM ja_cn_dff_assignments_v
    WHERE chart_of_accounts_id = pn_coa_id
      AND (lookup_code = 'FAAU' OR lookup_code = 'FAUM');

Line: 730

  SELECT COUNT(*) INTO ln_row_count
  FROM ja_cn_dep_meth_assignment
  WHERE legal_entity_id = pn_legal_entity_id;