APPS.GMD_SPEC_VRS_GRP dependencies on PO_VENDOR_SITES_ALL
Line 3402: FROM po_vendor_sites_all v
3398: AND nvl(v.end_date_active, sysdate+1);
3399:
3400: CURSOR c_supplier_site IS
3401: SELECT 1 3402: FROM po_vendor_sites_all v 3403: WHERE (v.purchasing_site_flag = 'Y'
3404: OR v.rfq_only_site_flag = 'Y')
3405: AND sysdate < NVL(inactive_date, sysdate + 1)
3406: AND v.vendor_id = p_supp_vr.supplier_id