Index: openacs-4/packages/news-portlet/www/news-portlet-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news-portlet/www/news-portlet-oracle.xql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/news-portlet/www/news-portlet-oracle.xql	12 May 2002 18:15:04 -0000	1.3
+++ openacs-4/packages/news-portlet/www/news-portlet-oracle.xql	4 Jun 2002 00:03:44 -0000	1.4
@@ -6,9 +6,7 @@
     <fullquery name="select_news_items">
         <querytext>
             select news_items_approved.package_id,
-                   (select ap1.instance_name
-                    from apm_packages ap1
-                    where ap1.package_id = apm_package.parent_id(news_items_approved.package_id)) as parent_name,
+                   acs_object.name(news_items_approved.package_id) as parent_name,
                    (select site_node.url(site_nodes.node_id)
                     from site_nodes
                     where site_nodes.object_id = news_items_approved.package_id) as url,