DBA Data[Home] [Help]

APPS.AP_WITHHOLDING_PKG dependencies on PO_VENDOR_SITES_ALL

Line 182: FROM po_vendor_sites_all

178: IF (l_income_tax_Region_flag = 'Y') THEN
179: BEGIN
180: SELECT SUBSTR(state, 1, 10)
181: INTO l_income_tax_region
182: FROM po_vendor_sites_all
183: WHERE vendor_site_id = rec_invoice.vendor_site_id
184: AND NVL(tax_reporting_site_flag, 'N') = 'Y';
185:
186: EXCEPTION

Line 872: po_vendor_sites_all s,

868: s.party_site_id,
869: pv.party_id
870: FROM ap_tax_codes_all t,
871: ap_system_parameters_all p,
872: po_vendor_sites_all s,
873: po_vendors pv
874: WHERE t.tax_id = TaxId
875: AND pv.vendor_id = s.vendor_id /* Bug 4724120 */
876: AND s.vendor_id = t.awt_vendor_id