APPS.GMF_AP_GET_INVOICE_PRICE dependencies on AP_HOLDS_ALL

Line 321: from ap_holds_all aph, ap_invoices_all api

317:
318: IF invoicenum IS NOT NULL THEN
319: select count(*)
320: into t_hold_count
321: from ap_holds_all aph, ap_invoices_all api
322: where
323: api.invoice_num = invoicenum
324: and api.invoice_id = aph.invoice_id
325: and aph.release_lookup_code is null;

Line 331: from ap_holds_all aph, ap_invoices_all api

327: /* Bug 2539636 : This condition never occurs. Also, this sql is the top one
328: performance repository.
329: select count(*)
330: into t_hold_count
331: from ap_holds_all aph, ap_invoices_all api
332: where
333: api.invoice_id = aph.invoice_id
334: and aph.release_lookup_code is null;
335: */