APPS.AP_PAY_IN_FULL_PKG dependencies on AP_INVOICES_ALL

Line 119: -- Go to base table AP_INVOICES_ALL to reduce shared memory usage

115:
116:
117:
118: -- Perf bugfix 5052493
119: -- Go to base table AP_INVOICES_ALL to reduce shared memory usage
120: SELECT a.payment_currency_code,
121: b.payment_method_code, --4552701
122: a.vendor_id,
123: a.vendor_site_id,

Line 156: FROM ap_invoices_all a, ap_payment_schedules_all b --Bug 7662240

152: P_remit_vendor_site_id,
153: p_remit_vendor_name,
154: p_remit_vendor_site_name,
155: p_relationship_id
156: FROM ap_invoices_all a, ap_payment_schedules_all b --Bug 7662240
157: WHERE a.invoice_id = l_invoice_id
158: and a.invoice_id = b.invoice_id
159: and rownum<2;
160:

Line 222: FROM ap_invoices_all

218: (p_remit_vendor_site_id = p_vendor_site_id) ) THEN
219:
220: SELECT party_id, party_site_id
221: INTO p_remit_party_id, p_remit_party_site_id
222: FROM ap_invoices_all
223: WHERE invoice_id = l_invoice_id;
224:
225: end if; --7860631
226: