3540: AND organization_id = p_spec.owner_organization_id;
3541:
3542: CURSOR c_supplier IS
3543: SELECT 1 3544: FROM po_vendors v 3545: WHERE v.vendor_id = p_supp_vr.supplier_id
3546: AND v.enabled_flag = 'Y'
3547: AND sysdate between nvl(v.start_date_active, sysdate-1)
3548: AND nvl(v.end_date_active, sysdate+1);