[Home] [Help]
2725:
2726: ----------------------------------------------------------
2727: -- This cursor gets the id from the header table for all the
2728: -- invoices which have payment due and the due date is less
2729: -- than the current date(this info is stored in ar_payment_schedules_all).
2730: -- So traverse from header to line to Streams table and then to the
2731: -- payments table.
2732: ----------------------------------------------------------
2733: CURSOR c_overdue_hdr(c_khr_id NUMBER)
2739: from okl_cnsld_ar_lines_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
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
2767: c.receivables_invoice_id = d.customer_trx_id and