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 privilege from acs_privileges
select privilege, child_privilege from acs_privilege_hierarchy
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