APPS.OKL_INVESTOR_INVOICE_DISB_PUB dependencies on OKL_TXL_AP_INV_LNS_V

Line 101: okl_txl_ap_inv_lns_v b

97:
98: CURSOR tap_cnt_succ_csr( p_req_id NUMBER ) IS
99: SELECT count(*)
100: FROM okl_trx_ap_invoices_v a,
101: okl_txl_ap_inv_lns_v b
102: WHERE a.id = b.tap_id AND
103: a.trx_status_code = 'ENTERED' AND
104: a.request_id = p_req_id ;
105:

Line 109: okl_txl_ap_inv_lns_v b

105:
106: CURSOR tap_cnt_err_csr( p_req_id NUMBER ) IS
107: SELECT count(*)
108: FROM okl_trx_ap_invoices_v a,
109: okl_txl_ap_inv_lns_v b
110: WHERE a.id = b.tap_id AND
111: a.trx_status_code = 'ERROR' AND
112: a.request_id = p_req_id ;
113: