DBA Data[Home] [Help]

APPS.IGI_CIS2007_IGIPSUPR_PKG dependencies on AP_SUPPLIER_SITES

Line 225: ap_supplier_sites pvs

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

Line 278: ap_supplier_sites pvs

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
282: AND accounting_date between p_start_date and p_end_date