APPS.AP_CANCEL_PKG dependencies on AP_INVOICE_PAYMENTS

Line 189: FROM ap_invoice_payments P,ap_payment_schedules PS

185: l_debug_info := 'Check if invoice has an effective payment';
186:
187: SELECT count(*)
188: INTO l_payment_count
189: FROM ap_invoice_payments P,ap_payment_schedules PS
190: WHERE P.invoice_id=PS.invoice_id
191: AND P.invoice_id = P_invoice_id
192: AND PS.payment_status_flag <> 'N'
193: AND nvl(P.reversal_flag,'N') <> 'Y'

Line 1385: FROM ap_invoice_payments aip,ap_invoices ai

1381: -- Bug 8257752. Commented out the reversal_flag condition.
1382:
1383: CURSOR invoices_cursor IS
1384: SELECT DISTINCT aip.invoice_id
1385: FROM ap_invoice_payments aip,ap_invoices ai
1386: WHERE aip.check_id = P_check_id
1387: --AND nvl(aip.reversal_flag, 'N') <> 'Y'
1388: AND ai.invoice_id=aip.invoice_id
1389: AND ai.cancelled_date is null;