APPS.OKL_VARIABLE_INTEREST_PVT dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 1253: AR_PAYMENT_SCHEDULES_ALL AR_PAY,

1249: -- Begin - Billing Inline changes - Bug#5898792 - varangan - 23/2/2007
1250: Cursor Principal_Paid_Cur (p_chr_id IN NUMBER, p_date IN DATE) IS
1251: SELECT NVL(SUM(AR_REC.AMOUNT_APPLIED),0) AMOUNT
1252: FROM AR_RECEIVABLE_APPLICATIONS_ALL AR_REC,
1253: AR_PAYMENT_SCHEDULES_ALL AR_PAY,
1254: okl_bpd_tld_ar_lines_v TLD,
1255: OKL_STRM_TYPE_B STRM
1256: WHERE AR_REC.APPLY_DATE <= p_date -- TO BE REPLACED WITH APPLY DATE
1257: AND TLD.KHR_ID = p_chr_id --298074492502791815515340871034511143040

Line 3542: ,ar_payment_schedules_all aps

3538: FROM
3539: okl_cnsld_ar_strms_b lsm
3540: ,okl_cnsld_ar_lines_b lln
3541: ,okl_cnsld_ar_hdrs_b cnr
3542: ,ar_payment_schedules_all aps
3543: ,ar_receivable_applications_all raa
3544: ,ar_cash_receipts_all cra
3545: ,okl_strm_type_v sty
3546: WHERE lsm.receivables_invoice_id > 0

Line 3578: ar_payment_schedules_all aps,

3574: FROM
3575: okl_cnsld_ar_strms_b lsm,
3576: okl_cnsld_ar_lines_b lln,
3577: okl_cnsld_ar_hdrs_b cnr,
3578: ar_payment_schedules_all aps,
3579: ar_receivable_applications_all raa,
3580: ar_cash_receipts_all cra,
3581: okl_strm_type_v sty_ln_pmt,
3582: okl_strm_elements_v sel_ln_pmt

Line 3915: ar_payment_schedules_all aps,

3911: 'R' txn_date
3912: FROM okl_cnsld_ar_strms_b lsm,
3913: okl_cnsld_ar_lines_b lln,
3914: okl_cnsld_ar_hdrs_b cnr,
3915: ar_payment_schedules_all aps,
3916: ar_receivable_applications_all raa,
3917: ar_cash_receipts_all cra,
3918: okl_strm_type_v sty
3919: WHERE lsm.receivables_invoice_id > 0

Line 3966: ar_payment_schedules_all aps,

3962: 'R' txn_date
3963: FROM okl_cnsld_ar_strms_b lsm,
3964: okl_cnsld_ar_lines_b lln,
3965: okl_cnsld_ar_hdrs_b cnr,
3966: ar_payment_schedules_all aps,
3967: ar_receivable_applications_all raa,
3968: ar_cash_receipts_all cra,
3969: okl_strm_type_v sty
3970: WHERE lsm.receivables_invoice_id > 0

Line 4282: ar_payment_schedules_all aps,

4278: FROM okl_txd_ar_ln_dtls_b tld,
4279: ra_customer_trx_lines_all ractrl,
4280: okl_txl_ar_inv_lns_b til,
4281: okl_trx_ar_invoices_b tai,
4282: ar_payment_schedules_all aps,
4283: ar_receivable_applications_all raa,
4284: ar_cash_receipts_all cra,
4285: okl_strm_type_b sty,
4286: ar_distributions_all ad

Line 4313: ar_payment_schedules_all aps,

4309: FROM okl_txd_ar_ln_dtls_b tld,
4310: ra_customer_trx_lines_all ractrl,
4311: okl_txl_ar_inv_lns_b til,
4312: okl_trx_ar_invoices_b tai,
4313: ar_payment_schedules_all aps,
4314: ar_receivable_applications_all raa,
4315: ar_cash_receipts_all cra,
4316: okl_strm_type_b sty
4317: WHERE tai.trx_status_code = 'PROCESSED'

Line 4889: ar_payment_schedules_all aps,

4885: SELECT cra.receipt_date txn_date,
4886: sum(raa.line_applied) txn_amount, -- 4884843, 4872370
4887: 'R' txn_type
4888: FROM okl_bpd_tld_ar_lines_v tld,
4889: ar_payment_schedules_all aps,
4890: ar_receivable_applications_all raa,
4891: ar_cash_receipts_all cra,
4892: okl_strm_type_v sty
4893: WHERE tld.trx_status_code = 'PROCESSED'

Line 7841: ,ar_payment_schedules_all aps

7837: FROM okl_txd_ar_ln_dtls_b tld
7838: ,ra_customer_trx_lines_all ractrl
7839: ,okl_txl_ar_inv_lns_b til
7840: ,okl_trx_ar_invoices_b tai
7841: ,ar_payment_schedules_all aps
7842: ,ar_receivable_applications_all raa
7843: ,ar_cash_receipts_all cra
7844: ,okl_strm_type_b sty
7845: WHERE tai.trx_status_code = 'PROCESSED'

Line 8134: ,ar_payment_schedules_all aps

8130: FROM okl_txd_ar_ln_dtls_b tld
8131: ,ra_customer_trx_lines_all ractrl
8132: ,okl_txl_ar_inv_lns_b til
8133: ,okl_trx_ar_invoices_b tai
8134: ,ar_payment_schedules_all aps
8135: ,ar_receivable_applications_all raa
8136: ,ar_cash_receipts_all cra
8137: ,okl_strm_type_b sty
8138: WHERE tai.trx_status_code = 'PROCESSED'