APPS.OKL_CONTRACT_APPROVAL_PVT dependencies on OKC_K_HEADERS_V

Line 272: SELECT sts_code FROM okc_k_headers_v WHERE contract_number = p_contract_number

268: x_activeyn OUT NOCOPY VARCHAR2) IS
269: l_name VARCHAR2(150);
270: l_wf_name VARCHAR(200);
271: CURSOR cur_contract_status IS
272: SELECT sts_code FROM okc_k_headers_v WHERE contract_number = p_contract_number
273: AND contract_number_modifier = p_contract_number_modifier;
274: l_sts_code VARCHAR2(200);
275:
276: BEGIN