APPS.AP_PREPAY_PKG dependencies on AP_INVOICE_PAYMENTS_ALL

Line 1568: AP_invoice_payments_all AIP

1564: AC.exchange_rate_type,
1565: AC.exchange_date,
1566: AC.exchange_rate
1567: FROM AP_checks_all AC,
1568: AP_invoice_payments_all AIP
1569: WHERE AC.check_id = AIP.check_id
1570: AND AIP.invoice_id = CV_PPAY_Invoice_ID
1571: AND NOT EXISTS (SELECT 'Invoice payment has been reversed'
1572: FROM AP_invoice_payments_all AIP2

Line 1572: FROM AP_invoice_payments_all AIP2

1568: AP_invoice_payments_all AIP
1569: WHERE AC.check_id = AIP.check_id
1570: AND AIP.invoice_id = CV_PPAY_Invoice_ID
1571: AND NOT EXISTS (SELECT 'Invoice payment has been reversed'
1572: FROM AP_invoice_payments_all AIP2
1573: WHERE AIP2.reversal_inv_pmt_id = AIP.invoice_payment_id
1574: AND AIP2.check_id = AC.check_id);
1575:
1576: CURSOR C_PPAY_DIST_INFO (CV_PPAY_Invoice_ID IN NUMBER,