DBA Data[Home] [Help]

APPS.OKL_CS_WF dependencies on OKL_CNSLD_AR_STRMS_B

Line 2735: okl_cnsld_ar_strms_b b

2731: where id in
2732: (select
2733: distinct b.lln_id
2734: from ar_payment_schedules_all a,
2735: okl_cnsld_ar_strms_b b
2736: where b.receivables_invoice_id=a.customer_trx_id
2737: and b.khr_id = c_khr_id
2738: and a.amount_due_remaining > 0
2739: and a.due_date < sysdate));

Line 2753: okl_cnsld_ar_strms_b c,

2749: c.khr_id
2750: from
2751: okl_cnsld_ar_hdrs_b a,
2752: okl_cnsld_ar_lines_b b,
2753: okl_cnsld_ar_strms_b c,
2754: ar_payment_schedules_all d
2755: where
2756: a.id=b.cnr_id and
2757: b.id=c.lln_id and

Line 3935: FROM OKL_CNSLD_AR_STRMS_B

3931:
3932: CURSOR get_sty_id(c_lsm_id IN NUMBER)
3933: IS
3934: SELECT sty_id
3935: FROM OKL_CNSLD_AR_STRMS_B
3936: WHERE id=c_lsm_id;
3937:
3938: BEGIN
3939: