APPS.OKL_VARIABLE_INTEREST_PVT dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 4279: ra_customer_trx_lines_all ractrl,

4275: p_due_date DATE) IS
4276: SELECT cra.receipt_date receipt_date
4277: ,SUM(nvl(ad.amount_cr,0))- SUM(nvl(ad.amount_dr,0)) principal_pmt_rcpt_amt -- 4884843, 4872370
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,

Line 4310: ra_customer_trx_lines_all ractrl,

4306: UNION ALL
4307: SELECT cra.receipt_date receipt_date
4308: ,SUM(raa.line_applied) principal_pmt_rcpt_amt -- 4884843, 4872370
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,

Line 7838: ,ra_customer_trx_lines_all ractrl

7834: -- invoices have lines from multiple contracts
7835: CURSOR l_rcpt_app_csr(cp_khr_id NUMBER, cp_from_date DATE) IS
7836: SELECT 'Y' return_value
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

Line 8131: ,ra_customer_trx_lines_all ractrl

8127: CURSOR l_rcpt_app_csr(cp_khr_id NUMBER, cp_from_date DATE, cp_to_date DATE) IS
8128: SELECT DISTINCT raa.receivable_application_id source_id
8129: , 'AR_RECEIVABLE_APPLICATIONS_ALL' source_table
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