217: END IF;
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
271: paid_status varchar2(8);
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