organisaatio
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
organisaatio_is_active(o organisaatio)
Parameters
Name
Type
Mode
o
organisaatio
IN
Definition
BEGIN RETURN o.alkupvm <= current_date AND(o.lakkautuspvm IS NULL OR current_date < o.lakkautuspvm) AND NOT o.organisaatiopoistettu; END;