DBA Data[Home] [Help]

APPS.POS_VENDOR_PUB_PKG dependencies on AP_SUPPLIER_SITES_ALL

Line 394: from ap_supplier_sites_all

390:
391:
392: select count(*)
393: into l_count
394: from ap_supplier_sites_all
395: where org_id = l_org_id
396: and primary_pay_site_flag = l_primary_pay_flag
397: and vendor_id = p_vendor_site_rec.vendor_id
398: and vendor_site_id <> l_vendor_site_id

Line 410: from ap_supplier_sites_all

406: end if;
407:
408: select vendor_site_code
409: into l_vendor_site_code
410: from ap_supplier_sites_all
411: where org_id = l_org_id
412: and primary_pay_site_flag = l_primary_pay_flag
413: and vendor_id = p_vendor_site_rec.vendor_id
414: and vendor_site_id <> l_vendor_site_id

Line 2420: FROM ap_supplier_sites_all

2416:
2417: -- Start Bug 6620664 - Handling Concurrent updates on Suppliers>>Accounting page
2418: IF p_last_update_date IS NOT NULL then
2419: SELECT last_update_date INTO l_last_update_date
2420: FROM ap_supplier_sites_all
2421: WHERE vendor_site_id = p_vendor_site_id
2422: AND vendor_id = p_vendor_id;
2423: IF l_last_update_date > p_last_update_date then
2424: x_error_msg := fnd_message.get_string('POS','POS_LOCK_SITE_ROW');