APPS.JTF_FM_OCM_REND_REQ dependencies on IBC_CONTENT_ITEMS

Line 316: ibc_content_items b,

312:
313: CURSOR get_file_query1_c is
314: SELECT attachment_file_id
315: FROM
316: ibc_content_items b,
317: ibc_citem_versions_vl a
318: WHERE
319: b.live_citem_version_id = a.citem_version_id
320: AND

Line 1100: FROM ibc_content_items

1096:
1097: -- When no version is passed in, we should use the live version.
1098: -- **** Query provided and approved by OCM in bug 4398752 ****
1099: SELECT live_citem_version_id INTO x_item_version_id
1100: FROM ibc_content_items
1101: WHERE content_item_id = p_content_id;
1102:
1103: END IF;
1104: