APPS.OKL_PROCESS_SALES_TAX_PVT dependencies on OKL_TRX_AR_INVOICES_B

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

8280:
8281: -- get the billing line details
8282: CURSOR l_txdarlndtls_csr(cp_sel_id IN NUMBER, cp_sty_id IN NUMBER) IS
8283: SELECT hdr.id trx_id, det.id trx_line_id
8284: FROM okl_trx_ar_invoices_b hdr, okl_txl_ar_inv_lns_b line, okl_txd_ar_ln_dtls_b det
8285: WHERE det.sel_id = cp_sel_id
8286: AND det.sty_id = cp_sty_id
8287: AND det.til_id_details = line.id
8288: AND line.tai_id = hdr.id;

Line 19088: FROM okl_trx_ar_invoices_b hdr, okl_txl_ar_inv_lns_b line,

19084: CURSOR l_billingdtls_csr(cp_det_line_id IN NUMBER) IS
19085: SELECT hdr.id hdr_id, hdr.khr_id, hdr.date_invoiced, hdr.try_id try_id,
19086: hdr.qte_id, hdr.ibt_id , hdr.legal_entity_id, line.id line_id, line.kle_id,
19087: line.isl_id, det.sty_id, det.amount
19088: FROM okl_trx_ar_invoices_b hdr, okl_txl_ar_inv_lns_b line,
19089: okl_txd_ar_ln_dtls_b det
19090: WHERE det.id = cp_det_line_id
19091: AND det.til_id_details = line.id
19092: AND line.tai_id = hdr.id;