APPS.OKL_PAY_INVOICES_TRANS_PVT dependencies on OKL_TXL_AP_INV_LNS_B

Line 62: FROM okl_txl_ap_inv_lns_b

58: WHERE cnsld_ap_inv_id = p_cnsld_ap_inv_id;
59:
60: CURSOR c_taxable_yn(p_tpl_id IN NUMBER) IS
61: SELECT taxable_yn
62: FROM okl_txl_ap_inv_lns_b
63: WHERE id = p_tpl_id;
64:
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

Line 103: FROM okl_txl_ap_inv_lns_b tpl

99:
100: CURSOR c_try_name(p_tpl_id IN NUMBER) IS
101: SELECT try.name try_name,
102: tpl.sty_id
103: FROM okl_txl_ap_inv_lns_b tpl
104: , okl_trx_ap_invoices_b tap
105: , okl_trx_types_v try
106: WHERE tpl.id = p_tpl_id
107: AND tpl.tap_id = tap.id

Line 132: , okl_txl_ap_inv_lns_b tpl

128: SELECT NVL(kle.cle_id, kle.id) top_kle_id
129: , kle.dnz_chr_id khr_id
130: -- , try.name try_name -- cklee 06/19/2007
131: FROM OKC_K_LINES_B kle
132: , okl_txl_ap_inv_lns_b tpl
133: , okl_trx_ap_invoices_b tap
134: , okl_trx_types_v try
135: WHERE tpl.id = p_tpl_id
136: AND tpl.kle_id = kle.id

Line 598: ,p_source_table => 'OKL_TXL_AP_INV_LNS_B'

594: ,x_msg_count => x_msg_count
595: ,x_msg_data => x_msg_data
596: ,p_source_trx_id => r_invoice_lines.tpl_id
597: ,p_source_trx_name => l_try_name
598: ,p_source_table => 'OKL_TXL_AP_INV_LNS_B'
599: ,x_tax_det_rec => lx_tax_det_rec);
600:
601:
602: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN