[Home] [Help]
2716:
2717: ----------------------------------------------------------
2718: -- This cursor gets the id from the header table for all the
2719: -- invoices which have payment due and the due date is less
2720: -- than the current date(this info is stored in ar_payment_schedules_all).
2721: -- So traverse from header to line to Streams table and then to the
2722: -- payments table.
2723: ----------------------------------------------------------
2724: CURSOR c_overdue_hdr(c_khr_id NUMBER)
2730: from okl_cnsld_ar_lines_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
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
2758: c.receivables_invoice_id = d.customer_trx_id and