APPS.OKL_STREAM_BILLING_PUB dependencies on OKL_TRX_AR_INVOICES_V

Line 191: FROM okl_trx_ar_invoices_v a,

187: FROM dual;
188:
189: CURSOR txd_cnt_succ_csr( p_req_id NUMBER ) IS
190: SELECT count(*)
191: FROM okl_trx_ar_invoices_v a,
192: okl_txl_ar_inv_lns_v b,
193: okl_txd_ar_ln_dtls_v c
194: WHERE a.id = b.tai_id AND
195: b.id = c.til_id_details AND

Line 201: FROM okl_trx_ar_invoices_v a,

197: a.request_id = p_req_id ;
198:
199: CURSOR txd_cnt_err_csr( p_req_id NUMBER ) IS
200: SELECT count(*)
201: FROM okl_trx_ar_invoices_v a,
202: okl_txl_ar_inv_lns_v b,
203: okl_txd_ar_ln_dtls_v c
204: WHERE a.id = b.tai_id AND
205: b.id = c.til_id_details AND