APPS.AP_UPDATE_1099_AWT_DISTS_PKG dependencies on PO_VENDOR_SITES

Line 23: FROM po_vendor_sites PVS,

19: l_debug_info := 'Get Income Tax Region';
20: --
21: SELECT SUBSTR(state, 1, 10)
22: INTO l_state
23: FROM po_vendor_sites PVS,
24: ap_invoices AI
25: WHERE AI.invoice_id = P_invoice_id
26: AND PVS.vendor_site_id = AI.vendor_site_id;
27: --

Line 127: po_vendor_sites PVS,

123: NVL(MAX(invoice_distribution_id),0)
124: INTO l_min_invoice_distribution_id, l_max_invoice_distribution_id
125: FROM ap_invoice_distributions ID,
126: ap_invoices AI,
127: po_vendor_sites PVS,
128: po_vendors PV
129: WHERE ID.invoice_id = AI.invoice_id
130: AND AI.vendor_site_id = PVS.vendor_site_id
131: AND PV.vendor_id = PVS.vendor_id

Line 178: po_vendor_sites PVS

174: WHERE ID.invoice_id IN (
175: SELECT AI.invoice_id
176: FROM ap_invoices AI,
177: po_vendors PV,
178: po_vendor_sites PVS
179: WHERE AI.vendor_id = PV.vendor_id
180: AND AI.vendor_site_id = PVS.vendor_site_id
181: AND PV.vendor_id = PVS.vendor_id
182: AND PV.federal_reportable_flag = 'Y'