Index: openacs-4/packages/curriculum-central/www/uos-details-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/curriculum-central/www/uos-details-postgresql.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/curriculum-central/www/uos-details-postgresql.xql	12 Feb 2006 12:42:48 -0000	1.2
+++ openacs-4/packages/curriculum-central/www/uos-details-postgresql.xql	15 Feb 2006 11:42:59 -0000	1.3
@@ -5,7 +5,7 @@
 
    <fullquery name="context_details">
      <querytext>
-       SELECT f.faculty_id, f.faculty_name, d.department_id, d.department_name,
+       SELECT f.faculty_id, f.faculty_name, d.department_name,
            s.stream_name, n.uos_code, n.uos_name
        FROM cc_faculty f, cc_department d, cc_stream s,
            cc_uos u, cc_uos_name n
@@ -18,6 +18,20 @@
      </querytext>
    </fullquery>
 
+   <fullquery name="context_details_no_stream">
+     <querytext>
+       SELECT f.faculty_id, f.faculty_name, d.department_name,
+           n.uos_code, n.uos_name
+       FROM cc_faculty f, cc_department d,
+           cc_uos u, cc_uos_name n
+       WHERE f.faculty_id = d.faculty_id
+           AND d.department_id = :department_id
+           AND d.package_id = :package_id
+	   AND u.uos_id = :uos_id
+	   AND n.name_id = u.uos_name_id
+     </querytext>
+   </fullquery>
+
    <fullquery name="uos_details">
      <querytext>
        SELECT ur.credit_value, ur.session_ids, ur.prerequisite_ids,