APPS.OKL_ARFETCH_PUB dependencies on OKL_CNSLD_AR_HDRS_B

Line 51: okl_cnsld_ar_hdrs_b cnr,

47: lsm.amount lsm_amount
48: FROM ra_customer_trx_lines_all trx,
49: okl_cnsld_ar_strms_b lsm,
50: okl_cnsld_ar_lines_b lln,
51: okl_cnsld_ar_hdrs_b cnr,
52: okl_xtl_sell_invs_b xls,
53: okl_ext_sell_invs_b xsi,
54: okl_strm_type_v sty
55: WHERE trx.line_type <> 'TAX'

Line 195: update okl_cnsld_ar_hdrs_b

191: end loop;
192:
193: forall indx in cnr_id_tbl.first..cnr_id_tbl.last
194: save exceptions
195: update okl_cnsld_ar_hdrs_b
196: set amount = 0
197: where id = cnr_id_tbl(indx);
198:
199:

Line 202: update okl_cnsld_ar_hdrs_b

198:
199:
200: forall indx in tax_amount_tbl.first..tax_amount_tbl.last
201: save exceptions
202: update okl_cnsld_ar_hdrs_b
203: set amount = amount + nvl(lsm_amount_tbl(indx),0) + nvl( tax_amount_tbl(indx), 0),
204: last_update_date = sysdate,
205: last_updated_by = lx_last_updated_by,
206: last_update_login = lx_last_update_login,

Line 289: UPDATE okl_cnsld_ar_hdrs_b

285: END LOOP;
286:
287: FORALL indx in customer_trx_id_tbl.FIRST..customer_trx_id_tbl.LAST
288: save exceptions
289: UPDATE okl_cnsld_ar_hdrs_b
290: SET due_date = due_date_tbl(indx),
291: last_update_date = sysdate,
292: last_updated_by = lx_last_updated_by,
293: last_update_login = lx_last_update_login,