APPS.OKL_PROCESS_SALES_TAX_PVT dependencies on OKL_TXL_AR_INV_LNS_B

Line 8253: FROM okl_trx_ar_invoices_b hdr, okl_txl_ar_inv_lns_b line, okl_txd_ar_ln_dtls_b det

8249:
8250: -- get the billing line details
8251: CURSOR l_txdarlndtls_csr(cp_sel_id IN NUMBER, cp_sty_id IN NUMBER) IS
8252: SELECT hdr.id trx_id, det.id trx_line_id
8253: FROM okl_trx_ar_invoices_b hdr, okl_txl_ar_inv_lns_b line, okl_txd_ar_ln_dtls_b det
8254: WHERE det.sel_id = cp_sel_id
8255: AND det.sty_id = cp_sty_id
8256: AND det.til_id_details = line.id
8257: AND line.tai_id = hdr.id;

Line 18937: FROM okl_trx_ar_invoices_b hdr, okl_txl_ar_inv_lns_b line,

18933: CURSOR l_billingdtls_csr(cp_det_line_id IN NUMBER) IS
18934: SELECT hdr.id hdr_id, hdr.khr_id, hdr.date_invoiced, hdr.try_id try_id,
18935: hdr.qte_id, hdr.ibt_id , hdr.legal_entity_id, line.id line_id, line.kle_id,
18936: line.isl_id, det.sty_id, det.amount
18937: FROM okl_trx_ar_invoices_b hdr, okl_txl_ar_inv_lns_b line,
18938: okl_txd_ar_ln_dtls_b det
18939: WHERE det.id = cp_det_line_id
18940: AND det.til_id_details = line.id
18941: AND line.tai_id = hdr.id;