postgresql7.4 SELECT cc_stream__name(:stream_id) SELECT map.uos_id, rev.year_id, rev.semester_ids, rev.core_id, rev.prerequisite_ids, rev.assumed_knowledge_ids, rev.corequisite_ids, rev.prohibition_ids, rev.no_longer_offered_ids FROM cc_stream_uos_map map, cc_stream_uos_map_rev rev WHERE map.map_id = :map_id AND rev.map_rev_id = map.latest_revision_id SELECT cc_stream_uos_map_rev__new ( NULL, :map_id, :year_id, :semester_ids, :core_id, :prerequisite_ids, :assumed_knowledge_ids, :corequisite_ids, :prohibition_ids, :no_longer_offered_ids, now(), :modifying_user, :modifying_ip )