APPS.PA_TRX_IMPORT dependencies on AP_INVOICE_PAYMENTS

Line 6926: from AP_Invoice_Payments

6922: where prepay_app_dist_id = NVL(l_SysRef4Tab(p_indx),0) ;
6923:
6924: cursor c_payment is
6925: select reversal_inv_pmt_id
6926: from AP_Invoice_Payments
6927: where Invoice_Payment_Id = NVL(l_SysRef4Tab(p_indx),0)
6928: and nvl(reversal_flag,'N') = 'Y' ;
6929:
6930: cursor c_invdist is

Line 11769: FROM ap_invoice_payments Pay,

11765: AND Paydist.invoice_distribution_id = p_sys_ref5
11766: AND PayDIST.invoice_payment_id = p_sys_ref4
11767: AND EXISTS
11768: (SELECT 1
11769: FROM ap_invoice_payments Pay,
11770: ap_invoices_all inv
11771: WHERE pay.invoice_payment_id = p_sys_ref4
11772: AND pay.invoice_id = inv.invoice_id
11773: AND NVL(pay.exchange_rate,0) <> NVL(inv.exchange_rate,0));