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
)