APPS.PA_TRX_IMPORT dependencies on AP_INVOICE_PAYMENTS

Line 7529: from AP_Invoice_Payments

7525: where prepay_app_dist_id = NVL(l_SysRef4Tab(p_indx),0) ;
7526:
7527: cursor c_payment is
7528: select reversal_inv_pmt_id
7529: from AP_Invoice_Payments
7530: where Invoice_Payment_Id = NVL(l_SysRef4Tab(p_indx),0)
7531: and nvl(reversal_flag,'N') = 'Y' ;
7532:
7533: cursor c_invdist is

Line 12662: FROM ap_invoice_payments Pay,

12658: AND Paydist.invoice_distribution_id = p_sys_ref5
12659: AND PayDIST.invoice_payment_id = p_sys_ref4
12660: AND EXISTS
12661: (SELECT 1
12662: FROM ap_invoice_payments Pay,
12663: ap_invoices_all inv
12664: WHERE pay.invoice_payment_id = p_sys_ref4
12665: AND pay.invoice_id = inv.invoice_id
12666: AND NVL(pay.exchange_rate,0) <> NVL(inv.exchange_rate,0));