APPS.JA_CN_APAR_EXPORT_PROG SQL Statements

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

Line: 97

  DELETE
    FROM   JA_CN_LEDGER_LE_BSV_GT;

Line: 312

       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 ASC)
       WHERE ROWNUM = 1;

Line: 332

       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: 378

      SELECT
        lookup_code
      INTO
        lv_pre_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_pre_status
        AND enabled_flag='Y'
        AND language = USERENV('LANG');

Line: 457

                    SELECT
                      lookup_code
                    INTO
                      lv_apv_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_apv_req_status
                      AND enabled_flag='Y'
                      AND language = USERENV('LANG');

Line: 507

                            SELECT
                              lookup_code
                            INTO
                              lv_arv_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_arv_req_status
                              AND enabled_flag='Y'
                              AND language = USERENV('LANG');