webco_8.0
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
find_res_current_sched_oid
Parameters
Name
Type
Mode
$1
bigint
IN
Definition
begin IF exists ( select null from ( select obj_oid from resource where obj_oid = $1) res) THEN return (select obj_oid from resource_schedule t1 where scheduled_resource_oid = $1 and type = 'CHECKOUT' limit 1); ELSE RETURN null; END IF; end