Index: openacs-4/packages/faq-portlet/www/faq-portlet-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/faq-portlet/www/Attic/faq-portlet-oracle.xql,v
diff -u -r1.8 -r1.9
--- openacs-4/packages/faq-portlet/www/faq-portlet-oracle.xql	12 Apr 2002 08:11:38 -0000	1.8
+++ openacs-4/packages/faq-portlet/www/faq-portlet-oracle.xql	4 Jun 2002 00:03:44 -0000	1.9
@@ -6,9 +6,7 @@
     <fullquery name="select_faqs">
         <querytext>
             select acs_objects.context_id as package_id,
-                   (select apm_packages.instance_name
-                    from apm_packages
-                    where apm_packages.package_id = apm_package.parent_id(acs_objects.context_id)) as parent_name,
+                   acs_object.name(acs_objects.context_id) as parent_name,
                    (select site_node.url(site_nodes.node_id)
                     from site_nodes
                     where site_nodes.object_id = acs_objects.context_id) as url,