APPS.OKL_VP_TERMINATE_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,
application_id,
scs_code
FROM okc_k_headers_b
WHERE id = p_terminate_in_parameters_rec.p_contract_id;

Line: 33

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

Line: 39

SELECT sts.ste_code,sts.meaning
FROM okc_statuses_v sts
WHERE sts.code = l_code;

Line: 44

SELECT 'x'
FROM  okx_incident_statuses_v xis,
okc_k_lines_b cle
WHERE cle.id = xis.contract_service_id
AND cle.dnz_chr_id = p_terminate_in_parameters_rec.p_contract_id
AND xis.status_code in ('OPEN'); -- Impact -- DepENDency on status of service requests

Line: 58

SELECT k.contract_number,k.contract_number_modifier
FROM okc_k_headers_b K,okc_operation_lines A,
okc_operation_instances B,okc_class_operations C
WHERE  K.id=A.subject_chr_id
AND A.object_chr_id=p_chr_id AND
C.id=B.cop_id and C.opn_code='RENEWAL'
AND B.id=A.oie_id AND A.active_yn='Y' AND
A.subject_cle_id IS NULL AND A.object_cle_id IS NULL;

Line: 245

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

Line: 251

    SELECT ste_code
    FROM   okc_statuses_b
    WHERE  code = p_code;

Line: 275

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

  l1_return_status :=OKL_API.G_RET_STS_ERROR;

Line: 280

                      p_msg_name      => 'OKL_VP_UPDATE_NOT_ALLOWED'
                     );

Line: 306

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

Line: 350

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