DBA Data[Home] [Help]

APPS.OKL_PAY_INVOICES_DISB_PVT dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 144: ra_customer_trx_lines_all ractrl

140: CURSOR l_receipt_amount_csr(cp_customer_trx_id NUMBER) IS
141: select nvl(sum(line_applied),0)
142: from ar_receivable_applications_all raa,
143: okl_txd_ar_ln_dtls_b tld,
144: ra_customer_trx_lines_all ractrl
145: WHERE tld.ID = ractrl.interface_line_attribute14
146: and raa.applied_customer_trx_id=cp_customer_trx_id
147: and raa.applied_customer_trx_id = ractrl.customer_trx_id
148: AND NOT EXISTS (SELECT 1 FROM OKL_INVESTOR_PAYOUT_SUMMARY_B PAY WHERE