323: CURSOR get_file_query2_c is
324: SELECT attachment_file_id
325: FROM ibc_citem_versions_vl a,
326: (SELECT MAX(version_number) version_number
327: FROM ibc_citem_versions_b
328: WHERE content_item_id=p_citem_id) b
329: WHERE
330: a.content_item_id = p_citem_id AND
331: a.version_number = b.version_number;
378:
379: -- SELECT attachment_file_id INTO file_id
380: -- FROM ibc_citem_versions_vl a,
381: -- (SELECT MAX(version_number) version_number
382: -- FROM ibc_citem_versions_b
383: -- WHERE content_item_id=p_citem_id) b
384: -- WHERE
385: -- a.content_item_id = p_citem_id AND
386: -- a.version_number = b.version_number;