218:
219: SELECT 'PAID'
220: INTO paid_status
221: FROM ap_checks ac,
222: ap_invoice_payments pay,
223: -- Bug 5642198 Start
224: ap_invoices inv,
225: ap_supplier_sites pvs
226: -- Bug 5642198 End
272: Begin
273: SELECT 'PAID'
274: INTO paid_status
275: FROM ap_checks ac,
276: ap_invoice_payments pay,
277: ap_invoices inv,
278: ap_supplier_sites pvs
279: WHERE ac.vendor_id = p_vendor_id
280: AND ac.void_date IS NULL