DBA Data[Home] [Help]

APPS.AP_WITHHOLDING_PKG dependencies on PO_VENDOR_SITES_ALL

Line 467: FROM po_vendor_sites_all

463: IF (l_income_tax_Region_flag = 'Y') THEN
464: BEGIN
465: SELECT SUBSTR(state, 1, 10)
466: INTO l_income_tax_region
467: FROM po_vendor_sites_all
468: WHERE vendor_site_id = rec_invoice.vendor_site_id
469: AND NVL(tax_reporting_site_flag, 'N') = 'Y';
470:
471: EXCEPTION

Line 1671: po_vendor_sites_all s,

1667: s.party_site_id,
1668: pv.party_id
1669: FROM ap_tax_codes_all t,
1670: ap_system_parameters_all p,
1671: po_vendor_sites_all s,
1672: po_vendors pv
1673: WHERE t.tax_id = TaxId
1674: AND pv.vendor_id = s.vendor_id /* Bug 4724120 */
1675: AND s.vendor_id = t.awt_vendor_id