APPS.OKC_EXTEND_PUB SQL Statements

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

Line: 282

  select k.id,k.end_date,k.object_version_number,k.contract_number,
         k.contract_number_modifier, k.sts_code
    from okc_k_headers_b k,
         okc_k_lines_b cle
   where cle.id = p_cle_id
     and cle.dnz_chr_id = k.id;

Line: 290

  SELECT ste_code
    FROM okc_statuses_b
   WHERE code = p_sts_code;

Line: 386

	  OKC_CONTRACT_PUB.update_contract_header ( p_api_version    => 1,
	                                   p_init_msg_list  => OKC_API.G_FALSE,
	                                   x_return_status  => l_return_status,
	                                   x_msg_count      => x_msg_count,
	                                   x_msg_data       => x_msg_data,
				    p_restricted_update => okc_api.g_true,
	                                   p_chrv_rec       => l_chr_rec,
	                                   x_chrv_rec       => i_chr_rec  );