APPS.AP_INVOICES_POST_PROCESS_PKG dependencies on PO_VENDOR_SITES

Line 22: PO_VENDOR_SITES.invoice_amount_limit%TYPE;

18: l_base_amount AP_INVOICES.base_amount%TYPE;
19: l_invoice_currency_code
20: AP_INVOICES.invoice_currency_code%TYPE;
21: l_invoice_amount_limit
22: PO_VENDOR_SITES.invoice_amount_limit%TYPE;
23: l_base_currency_code
24: AP_SYSTEM_PARAMETERS.base_currency_code%TYPE;
25: l_hold_future_payments_flag
26: PO_VENDOR_SITES.hold_future_payments_flag%TYPE;

Line 26: PO_VENDOR_SITES.hold_future_payments_flag%TYPE;

22: PO_VENDOR_SITES.invoice_amount_limit%TYPE;
23: l_base_currency_code
24: AP_SYSTEM_PARAMETERS.base_currency_code%TYPE;
25: l_hold_future_payments_flag
26: PO_VENDOR_SITES.hold_future_payments_flag%TYPE;
27:
28: -- perf bug 5052699 - below sql tuned so as to go to base tables
29:
30: cursor invoice_cursor is

Line 40: po_vendor_sites VS

36: nvl(VS.hold_future_payments_flag,'N')
37: from ap_invoices_all AI,
38: ap_batches_all AB,
39: ap_system_parameters_all SP,
40: po_vendor_sites VS
41: where AI.invoice_id = X_invoice_id
42: and AI.batch_id = AB.batch_id (+)
43: and AI.vendor_site_id = VS.vendor_site_id
44: and sp.org_id = ai.org_id