APPS.OKL_STREAM_BILLING_PUB dependencies on OKL_TXD_AR_LN_DTLS_V

Line 186: okl_txd_ar_ln_dtls_v c

182: CURSOR txd_cnt_succ_csr( p_req_id NUMBER ) IS
183: SELECT count(*)
184: FROM okl_trx_ar_invoices_v a,
185: okl_txl_ar_inv_lns_v b,
186: okl_txd_ar_ln_dtls_v c
187: WHERE a.id = b.tai_id AND
188: b.id = c.til_id_details AND
189: a.trx_status_code = 'PROCESSED' AND
190: a.request_id = p_req_id ;

Line 196: okl_txd_ar_ln_dtls_v c

192: CURSOR txd_cnt_err_csr( p_req_id NUMBER ) IS
193: SELECT count(*)
194: FROM okl_trx_ar_invoices_v a,
195: okl_txl_ar_inv_lns_v b,
196: okl_txd_ar_ln_dtls_v c
197: WHERE a.id = b.tai_id AND
198: b.id = c.til_id_details AND
199: a.trx_status_code = 'ERROR' AND
200: a.request_id = p_req_id ;