APPS.AP_VENDOR_SITES_PKG dependencies on PO_VENDOR_SITES_ALL

Line 246: from po_vendor_sites_all

242: made earlier (Bug 702458)
243: debug_info := 'Select vendor site id for any other site with same site_code';
244: Select max(vendor_site_id)
245: into x_vendor_site_id
246: from po_vendor_sites_all
247: where vendor_id = x_vendor_id
248: and vendor_site_code = x_vendor_site_code; */
249:
250: --(Bug 702458) if (x_vendor_site_id IS NULL) then

Line 1639: from po_vendor_sites_all

1635: where rowid = X_rowid;
1636:
1637: select count(*)
1638: into total_sites
1639: from po_vendor_sites_all
1640: where vendor_site_id = X_vendor_site_id;
1641:
1642: if ( total_sites > 1 and ( vendor_site_old <> X_vendor_site_code)) then
1643: fnd_message.set_name('SQLAP','AP_SHARED_SITE');

Line 2197: FROM po_vendor_sites_all

2193: -- select the tax site
2194:
2195: SELECT vendor_site_code
2196: INTO x_vendor_site_code
2197: FROM po_vendor_sites_all
2198: WHERE vendor_id = x_vendor_id
2199: AND nvl(org_id,-99) = nvl(x_org_id,-99)
2200: AND Tax_Reporting_Site_Flag = 'Y';
2201: