APPS.OKL_AM_INTEGRATION_PVT dependencies on OKC_K_HEADERS_B

Line 38: l_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE := NULL;

34: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
35: lx_quote_tbl OKL_AM_UTIL_PVT.quote_tbl_type;
36: lp_canceled_qtev_rec OKL_QTE_PVT.qtev_rec_type;
37: lx_canceled_qtev_rec OKL_QTE_PVT.qtev_rec_type;
38: l_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE := NULL;
39: i NUMBER;
40: l_quote_id NUMBER;
41: -- cursor to check whether contract is valid or not
42: CURSOR is_khr_exists_csr IS

Line 44: FROM OKC_K_HEADERS_B

40: l_quote_id NUMBER;
41: -- cursor to check whether contract is valid or not
42: CURSOR is_khr_exists_csr IS
43: SELECT contract_number
44: FROM OKC_K_HEADERS_B
45: WHERE id = p_khr_id;
46:
47: -- SECHAWLA 23-OCT-03 : Added this cursor
48: -- get the quote id from the termination transaction