APPS.OKL_CONVERT_INT_TYPE_WF SQL Statements

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

Line: 22

        SELECT  application_id
        FROM    fnd_application_vl
        WHERE   application_short_name = x_short_name;

Line: 27

        SELECT  msg.message_number
        FROM    fnd_new_messages msg, fnd_languages_vl lng
        WHERE   msg.message_name = x_msg
          and   msg.application_id = x_id
          and   lng.LANGUAGE_CODE = msg.language_code
          and   lng.language_id = x_lang_id;

Line: 89

    SELECT okl_wf_item_s.nextval
    FROM  dual;

Line: 107

    l_parameter_list.DELETE;

Line: 160

      SELECT chrv.contract_number
      FROM okc_k_headers_v chrv
      WHERE chrv.id = p_contract_id;

Line: 166

      SELECT *
      FROM okl_trx_requests trx
      WHERE trx.id = p_request_id;

Line: 172

      SELECT *
      FROM OKL_CONVERT_INT_RATE_REQUEST_V
      WHERE TRQ_ID = p_request_id;

Line: 180

      SELECT *
      FROM OKL_K_RATE_PARAMS_V
      WHERE KHR_ID = p_contract_id
      AND   EFFECTIVE_FROM_DATE = p_effective_date
      AND   PARAMETER_TYPE_CODE = p_parameter_type_code;

Line: 188

      SELECT NAME
      FROM OKL_INDICES
      WHERE ID = p_index_id;

Line: 194

      SELECT NAME
      FROM OKL_FORMULAE_V
      WHERE ID = p_formula_id;

Line: 201

      SELECT meaning
      FROM fnd_lookups
      WHERE lookup_type = p_lookup_type
      AND lookup_code = p_lookup_code;

Line: 711

          okl_trx_requests_pub.update_trx_requests(
                                           p_api_version         => l_api_version,
                                           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_trqv_rec            => l_trq_rec,
                                           x_trqv_rec            => lx_trq_rec);