APPS.OKL_VP_EXTEND_PVT SQL Statements

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

Line: 14

  SELECT
  sts_code,
  contract_number,
  contract_number_modifier,
  template_yn,
  date_terminated,
  date_renewed,
  end_date
  FROM okc_k_headers_b
  WHERE id = p_extend_in_parameters_rec.p_contract_id;

Line: 26

  SELECT 'Y'
  FROM okc_k_processes v
  WHERE v.chr_id = p_extend_in_parameters_rec.p_contract_id
  AND v.in_process_yn='Y';

Line: 32

  SELECT ste_code
  FROM okc_statuses_b
  WHERE code = p_sts_code;

Line: 37

  SELECT meaning
  FROM okc_statuses_v
  WHERE code = p_sts_code;

Line: 190

    SELECT sts_code,template_yn,end_date,application_id,scs_code ,contract_number,
			contract_number_modifier
    FROM   okc_k_headers_b
    WHERE  id = p_chr_id;

Line: 196

    SELECT ste_code
    FROM   okc_statuses_b
    WHERE  code = p_code;

Line: 232

                        p_msg_name      => 'OKL_NO_UPDATE',
		        p_token1        => 'CHR',
			p_token1_value  => l_k);

Line: 244

/*  IF (OKL_OKC_MIGRATION_A_PVT.update_allowed(p_chr_id) <> 'Y') THEN

  -- l1_return_status :=OKL_API.G_RET_STS_ERROR;

Line: 249

                      p_msg_name      => 'OKL_VP_UPDATE_NOT_ALLOWED'
	             );

Line: 300

SELECT contract_number,scs_code,sts_code,start_date,end_date FROM okc_k_headers_v
WHERE id=p_id;