APPS.OKL_INTEREST_IMP_PVT SQL Statements

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

Line: 40

  SELECT id,
         idi_type,
         process_flag,
         index_name,
         description,
         value,
         datetime_valid,
         datetime_invalid
  FROM OKL_INDX_INTERFACES_V
  WHERE process_flag IS NULL
  ORDER BY idi_type, datetime_valid
  FOR UPDATE;

Line: 56

  SELECT name,
      id
  FROM okl_indices_v
  WHERE name = v_name
  AND   idx_type = v_idx_type;

Line: 200

    OKL_INDEX_INTERFACES_PUB.update_index_interfaces(p_api_version   => 1.0,
                                                     p_init_msg_list => l_init_msg_list,
                                                     x_return_status => l_return_status,
                                                     x_msg_count     => l_msg_count,
                                                     x_msg_data      => l_msg_data,
                                                     p_idiv_tbl      => l_idiv_tbl_in,
                                                     x_idiv_tbl      => l_idiv_tbl_out);