DBA Data[Home] [Help]

APPS.IGI_CIS2007_IGIPSUPR_PKG dependencies on AP_INVOICES

Line 224: ap_invoices inv,

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
227: WHERE ac.vendor_id = l_vendor_id
228: AND ac.void_date IS NULL

Line 277: ap_invoices inv,

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
281: AND pay.check_id = ac.check_id