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: --Bug10034598: Commected below query
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 202: FROM ap_invoice_payments P

198: and void_date is null);*/--Bug 6135172
199: --Bug10034598 : Removed join with ap_payment_schedules
200: SELECT COUNT(*)
201: INTO l_payment_count
202: FROM ap_invoice_payments P
203: WHERE P.invoice_id = P_invoice_id
204: AND NVL(P.reversal_flag,'N') <> 'Y'
205: AND P.amount IS NOT NULL
206: AND EXISTS

Line 702: FROM ap_invoice_payments AIP

698: AND AID.awt_invoice_payment_id IS NULL ;
699:
700: SELECT TRUNC( NVL( MAX( AIP.accounting_date ) , P_accounting_date ) )
701: INTO l_max_pmt_acc_date
702: FROM ap_invoice_payments AIP
703: WHERE AIP.invoice_id = P_invoice_id ;
704:
705: SELECT org_id
706: INTO l_org_id

Line 1545: FROM ap_invoice_payments aip,ap_invoices ai

1541: -- Bug 8257752. Commented out the reversal_flag condition.
1542:
1543: CURSOR invoices_cursor IS
1544: SELECT DISTINCT aip.invoice_id
1545: FROM ap_invoice_payments aip,ap_invoices ai
1546: WHERE aip.check_id = P_check_id
1547: --AND nvl(aip.reversal_flag, 'N') <> 'Y'
1548: AND ai.invoice_id=aip.invoice_id
1549: AND ai.cancelled_date is null;