select item_id from cr_items where parent_id = :p_parent_id and name = 'news' select news_id, package_id, archive_date, approval_user, approval_date, approval_ip from cr_news where news_id = :p_news_id select item_id, title, description, publish_date, mime_type, nls_language, content, content_length from cr_revisions where revision_id = :p_revision_id select parent_id, name, live_revision, latest_revision, publish_status, content_type from cr_items where item_id = :p_item_id select object_type, supertype from acs_object_types where object_type = 'news' select attribute_name from acs_attributes where object_type = 'news' select folder_id from cr_folders where label = 'news' select count(*) from news_items_approved select count(*) from news_items_live_or_submitted select count(*) from news_items_unapproved select count(*) from news_item_revisions select count(*) from news_item_unapproved select count(*) from news_item_full_active