APPS.OKL_CONTRACT_APPROVAL_PVT SQL Statements

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

Line: 24

  	SELECT khr_id FROM okl_k_headers_full_v
  	WHERE id = p_contract_id;

Line: 28

  	SELECT id FROM okl_k_headers_full_v
  	WHERE khr_id = p_khr_id
  	AND sts_code = 'ACTIVE';

Line: 75

cursor pdf_cur is select pdf_id from okc_k_processes where chr_id = p_contract_id;

Line: 85

CURSOR khr_num IS SELECT contract_number  , authoring_org_id  FROM okc_k_headers_b
  WHERE id = (SELECT khr_id FROM okl_k_headers_full_v
              WHERE id = p_contract_id);

Line: 135

OKC_CONTRACT_PUB.update_contract_header(
    p_api_version	=> p_api_version,
    x_return_status	=> x_return_status,
    p_init_msg_list     => OKL_API.G_TRUE,
    x_msg_count		=> x_msg_count,
    x_msg_data		=> x_msg_data,
    p_restricted_update	=> OKL_API.G_FALSE,
    p_chrv_rec		=> l1_header_rec,
    x_chrv_rec		=> l2_header_rec);

Line: 272

  SELECT sts_code FROM okc_k_headers_v WHERE contract_number = p_contract_number
  AND contract_number_modifier = p_contract_number_modifier;