APPS.AP_UPDATE_1099_AWT_DISTS_PKG dependencies on PO_VENDORS

Line 66: l_federal_reportable_flag po_vendors.federal_reportable_flag%TYPE;

62: l_count INTEGER := 0;
63: l_total_count INTEGER := 0;
64: --
65: l_enable_1099_on_awt_flag ap_system_parameters.enable_1099_on_awt_flag%TYPE;
66: l_federal_reportable_flag po_vendors.federal_reportable_flag%TYPE;
67: l_type_1099 ap_invoice_distributions.type_1099%TYPE;
68: l_combined_filing_flag ap_system_parameters.combined_filing_flag%TYPE;
69: l_income_tax_region_asp ap_system_parameters.income_tax_region%TYPE;
70: l_income_tax_region_pvs ap_system_parameters.income_tax_region%TYPE;

Line 128: po_vendors PV

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
132: AND PV.federal_reportable_flag = 'Y'

Line 177: po_vendors PV,

173: ID.request_id = l_request_id
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