APPS.OKL_AM_AMORTIZE_PVT dependencies on OKC_K_HEADERS_B

Line 50: FROM okc_k_headers_b a, okl_k_headers b

46:
47: -- Get the financial product of the contract
48: CURSOR l_get_fin_product(cp_khr_id IN NUMBER) IS
49: SELECT a.start_date, a.contract_number, b.pdt_id
50: FROM okc_k_headers_b a, okl_k_headers b
51: WHERE a.id = b.id
52: AND a.id = cp_khr_id;
53:
54: SUBTYPE pdtv_rec_type IS OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;

Line 4598: FROM okc_k_headers_b

4594: -- SECHAWLA 19-NOV-2004 4022466 :added
4595: -- get the contract status
4596: CURSOR l_okckhdr_csr(cp_khr_id IN NUMBER) IS
4597: SELECT sts_code
4598: FROM okc_k_headers_b
4599: WHERE id = cp_khr_id;
4600:
4601: -- SECHAWLA 19-NOV-2004 4022466 :added
4602: -- get the active financial asset lines for the contract