APPS.AP_VENDOR_SITES_PKG dependencies on AP_SUPPLIER_SITES_ALL

Line 259: INSERT INTO ap_supplier_sites_all(

255: from sys.dual;
256: -- end if;
257:
258: debug_info := 'Insert values into ap_supplier_sites';
259: INSERT INTO ap_supplier_sites_all(
260: vendor_site_id,
261: last_update_date,
262: last_updated_by,
263: vendor_id,

Line 580: INSERT INTO ap_supplier_sites_all(

576: from sys.dual;
577: -- end if;
578:
579: debug_info := 'Insert values into ap_supplier_sites';
580: INSERT INTO ap_supplier_sites_all(
581: vendor_site_id,
582: last_update_date,
583: last_updated_by,
584: vendor_id,

Line 1907: UPDATE ap_supplier_sites_all

1903: FROM ap_suppliers
1904: WHERE vendor_id = p_vendor_site_rec.Vendor_Id;
1905: --Bug15966842
1906:
1907: UPDATE ap_supplier_sites_all
1908: SET
1909: last_update_date = p_Last_Update_Date,
1910: last_updated_by = p_Last_Updated_By,
1911: vendor_id = p_vendor_site_rec.Vendor_Id,

Line 2281: FROM ap_supplier_sites_all

2277: -- select the tax site
2278:
2279: SELECT vendor_site_code
2280: INTO x_vendor_site_code
2281: FROM ap_supplier_sites_all
2282: WHERE vendor_id = x_vendor_id
2283: AND nvl(org_id,-99) = nvl(x_org_id,-99)
2284: AND Tax_Reporting_Site_Flag = 'Y';
2285: