APPS.OKL_PAY_INVOICES_TRANS_PVT dependencies on OKC_K_HEADERS_B

Line 69: FROM okc_k_headers_b chr

65: -- sjalasut, modified code to refer khr_id from okl_txl_ap_inv_lns_all_b instead of okl_trx_ap_invoices_b
66: -- changes made as part of OKLR12B disbursements project
67: CURSOR c_num_csr ( p_id NUMBER ) IS
68: SELECT CHR.CONTRACT_NUMBER
69: FROM okc_k_headers_b chr
70: ,okl_txl_ap_inv_lns_all_b tpl
71: ,okl_xtl_pay_invs_all_b xlp
72: WHERE XLP.ID = p_id
73: AND XLP.tpl_id = TPL.id

Line 83: FROM okc_k_headers_b chr

79: -- changes made as part of OKLR12B disbursements project
80: /* rkuttiya commented this cursor as no longer required */
81: /* CURSOR c_fun_csr ( p_id NUMBER ) IS
82: SELECT CHR.CONTRACT_NUMBER
83: FROM okc_k_headers_b chr
84: ,okl_trx_ap_invoices_b tap
85: ,okl_txl_ap_inv_lns_all_b tpl
86: ,okl_xtl_pay_invs_all_b xlp
87: WHERE XLP.XPI_ID_DETAILS = p_id

Line 220: FROM okc_k_headers_b khr

216:
217: CURSOR get_khr_id_csr ( p_khr_id VARCHAR2 ) IS
218: SELECT cust_acct_id,
219: sts_code --07-May-2008 cklee -- Fixed bug:7015970
220: FROM okc_k_headers_b khr
221: where khr.id = p_khr_id;
222:
223: /*--07-May-2008 cklee -- Fixed bug:7015970
224: CURSOR Ship_to_csr2( p_customer_num NUMBER, p_install_location NUMBER, p_location NUMBER) IS