APPS.OKL_STREAM_BILLING_PUB dependencies on OKL_TXD_AR_LN_DTLS_V

Line 193: okl_txd_ar_ln_dtls_v c

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
196: a.trx_status_code = 'PROCESSED' AND
197: a.request_id = p_req_id ;

Line 203: okl_txd_ar_ln_dtls_v c

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
206: a.trx_status_code = 'ERROR' AND
207: a.request_id = p_req_id ;