select item_id from cr_revisions where revision_id=:object_id select package_id from cr_news where news_id=:object_id select max(o.last_modified) from acs_objects o, cr_news n where n.package_id=:package_id and o.object_id=n.news_id select ao.object_id as package_id from acs_objects ao, apm_packages ap, dotlrn_communities_all dc where ao.object_type = 'apm_package' and ao.context_id = dc.package_id and dc.community_id = :community_id and ao.object_id = ap.package_id and ap.package_key = 'news' select news__new( null, -- p_item_id null, -- p_locale :publish_date_ansi, -- p_publish_date :publish_body, -- p_text null, -- p_nls_language :publish_title, -- p_title :mime_type, -- p_mime_type :package_id, -- p_package_id :archive_date_ansi, -- p_archive_date :approval_user, -- p_approval_user :approval_date, -- p_approval_date :approval_ip, -- p_approval_ip null, -- p_relation_tag :creation_ip, -- p_creation_ip :user_id, -- p_creation_user :live_revision_p -- p_is_live_p )