APPS.GMD_SPEC_VRS_GRP dependencies on PO_VENDOR_SITES_ALL
Line 3552: FROM po_vendor_sites_all v
3548: AND nvl(v.end_date_active, sysdate+1);
3549:
3550: CURSOR c_supplier_site IS
3551: SELECT 1 3552: FROM po_vendor_sites_all v 3553: WHERE (v.purchasing_site_flag = 'Y'
3554: OR v.rfq_only_site_flag = 'Y')
3555: AND sysdate < NVL(inactive_date, sysdate + 1)
3556: AND v.vendor_id = p_supp_vr.supplier_id