APPS.OKL_AM_INTEGRATION_PVT SQL Statements

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

Line: 43

    SELECT contract_number
    FROM OKC_K_HEADERS_B
    WHERE id = p_khr_id;

Line: 50

  SELECT qte_id
  FROM   OKL_TRX_CONTRACTS
  WHERE  id = cp_trx_id;

Line: 56

      SELECT NVL(upper(CANCEL_QUOTES_YN), 'N') CANCEL_QUOTES
      FROM   OKL_SYSTEM_PARAMS;

Line: 176

                OKL_TRX_QUOTES_PUB.update_trx_quotes( p_api_version     => p_api_version,
                                                      p_init_msg_list   => OKL_API.G_FALSE,
                                                      x_return_status   => l_return_status,
                                                      x_msg_count       => x_msg_count,
                                                      x_msg_data        => x_msg_data,
                                                      p_qtev_rec        => lp_canceled_qtev_rec,
                                                      x_qtev_rec        => lx_canceled_qtev_rec);