postgresql7.4
select p.instance_name, o.creation_user, o.creation_ip
from apm_packages p join acs_objects o on (p.package_id = o.object_id)
where p.package_id = :curriculum_id
SELECT 1 from cc_curriculum where curriculum_id = :curriculum_id
INSERT INTO cc_curriculum (curriculum_id, folder_id, root_keyword_id)
VALUES (:curriculum_id, :folder_id, :keyword_id)
SELECT cc_curriculum__delete(:curriculum_id)
SELECT first_names || ' ' || last_name || ' (' || email || ')' AS name,
user_id
FROM cc_users
SELECT department_name, department_id FROM cc_department
WHERE package_id = :package_id