3390: AND organization_id = p_spec.owner_organization_id;
3391:
3392: CURSOR c_supplier IS
3393: SELECT 1 3394: FROM po_vendors v 3395: WHERE v.vendor_id = p_supp_vr.supplier_id
3396: AND v.enabled_flag = 'Y'
3397: AND sysdate between nvl(v.start_date_active, sysdate-1)
3398: AND nvl(v.end_date_active, sysdate+1);