APPS.OKL_PAY_CURE_REFUNDS_PVT dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 649: ,ar_payment_schedules_all aps

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')
653: AND (aps.due_date + p_grace_days) < sysdate

Line 660: ,ar_payment_schedules_all aps

656: CURSOR c_amount_past_due(p_contract_id IN NUMBER,
657: p_grace_days IN NUMBER) IS
658: SELECT SUM(NVL(aps.amount_due_remaining, 0)) past_due_amount
659: FROM okl_bpd_tld_ar_lines_v ocas
660: ,ar_payment_schedules_all aps
661: WHERE ocas.khr_id = p_contract_id
662: AND ocas.customer_trx_id = aps.customer_trx_id
663: AND aps.class IN ('INV','CM')
664: AND (aps.due_date + p_grace_days) < sysdate

Line 703: ar_payment_schedules_all ps,

699: FROM okl_xtl_sell_invs_v xls,
700: okl_txl_ar_inv_lns_v til,
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

Line 731: ar_payment_schedules_all ps,

727: FROM okl_xtl_sell_invs_v xls,
728: okl_txl_ar_inv_lns_b til,
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,

Line 769: ar_payment_schedules_all ps,

765: FROM okl_xtl_sell_invs_v xls,
766: okl_txl_ar_inv_lns_b til,
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,