APPS.OKL_CS_WF dependencies on OKL_CNSLD_AR_STRMS_B

Line 2744: okl_cnsld_ar_strms_b b

2740: where id in
2741: (select
2742: distinct b.lln_id
2743: from ar_payment_schedules_all a,
2744: okl_cnsld_ar_strms_b b
2745: where b.receivables_invoice_id=a.customer_trx_id
2746: and b.khr_id = c_khr_id
2747: and a.amount_due_remaining > 0
2748: and a.due_date < sysdate));

Line 2762: okl_cnsld_ar_strms_b c,

2758: c.khr_id
2759: from
2760: okl_cnsld_ar_hdrs_b a,
2761: okl_cnsld_ar_lines_b b,
2762: okl_cnsld_ar_strms_b c,
2763: ar_payment_schedules_all d
2764: where
2765: a.id=b.cnr_id and
2766: b.id=c.lln_id and

Line 3944: FROM OKL_CNSLD_AR_STRMS_B

3940:
3941: CURSOR get_sty_id(c_lsm_id IN NUMBER)
3942: IS
3943: SELECT sty_id
3944: FROM OKL_CNSLD_AR_STRMS_B
3945: WHERE id=c_lsm_id;
3946:
3947: BEGIN
3948: