APPS.GMD_SAMPLES_PUB dependencies on PO_VENDOR_SITES_ALL

Line 2148: FROM po_vendor_sites_all v

2144: AND v.enabled_flag = 'Y';
2145:
2146: CURSOR c_supplier_site IS
2147: SELECT 1
2148: FROM po_vendor_sites_all v
2149: WHERE (v.purchasing_site_flag = 'Y'
2150: OR v.rfq_only_site_flag = 'Y')
2151: AND sysdate < NVL(inactive_date, sysdate + 1)
2152: AND v.vendor_id = p_sample_rec.supplier_id