APPS.OKL_PAY_CURE_REFUNDS_PVT dependencies on OKL_CNSLD_AR_STRMS_B

Line 648: FROM okl_cnsld_ar_strms_b ocas

644:
645: /*CURSOR c_amount_past_due(p_contract_id IN NUMBER,
646: p_grace_days IN NUMBER) IS
647: SELECT SUM(NVL(aps.amount_due_remaining, 0)) past_due_amount
648: FROM okl_cnsld_ar_strms_b ocas
649: ,ar_payment_schedules_all aps
650: WHERE ocas.khr_id = p_contract_id
651: AND ocas.receivables_invoice_id = aps.customer_trx_id
652: AND aps.class IN ('INV','CM')

Line 705: okl_cnsld_ar_strms_b st

701: okl_trx_ar_invoices_v tai,
702: okc_k_headers_b cn,
703: ar_payment_schedules_all ps,
704: ar_receivable_applications_all arapp,
705: okl_cnsld_ar_strms_b st
706: WHERE st.id = xls.lsm_id
707: AND st.receivables_invoice_id = ps.customer_trx_id
708: AND ps.class IN('INV', 'CM')
709: AND arapp.applied_payment_schedule_id = ps.payment_schedule_id

Line 733: okl_cnsld_ar_strms_b st,

729: okl_trx_ar_invoices_b tai,
730: okc_k_headers_all_b cn,
731: ar_payment_schedules_all ps,
732: ar_receivable_applications_all arapp,
733: okl_cnsld_ar_strms_b st,
734: okc_k_party_roles_b pty,
735: okc_rules_b rul,
736: okc_k_headers_b CHR,
737: po_vendors pvn,

Line 771: okl_cnsld_ar_strms_b st,

767: okl_trx_ar_invoices_b tai,
768: okc_k_headers_b cn,
769: ar_payment_schedules_all ps,
770: ar_receivable_applications_all arapp,
771: okl_cnsld_ar_strms_b st,
772: okc_k_party_roles_b pty,
773: okc_rules_b rul,
774: okc_k_headers_all_b CHR,
775: po_vendors pvn