DBA Data[Home] [Help]

APPS.IBC_UTILITIES_GRP dependencies on IBC_CITEM_VERSIONS_B

Line 230: FROM ibc_citem_versions_b civb,

226: CURSOR c_item_name(p_content_item_id NUMBER,
227: p_language VARCHAR2)
228: IS
229: SELECT MAX(civtl.content_item_name)
230: FROM ibc_citem_versions_b civb,
231: ibc_citem_versions_tl civtl
232: WHERE civb.content_item_id = p_content_item_id
233: AND civb.citem_version_id = civtl.citem_version_id
234: AND language = p_language;

Line 373: FROM ibc_citem_versions_b civb,

369: CURSOR c_item_name(p_content_item_id NUMBER,
370: p_language VARCHAR2)
371: IS
372: SELECT MAX(civtl.content_item_name)
373: FROM ibc_citem_versions_b civb,
374: ibc_citem_versions_tl civtl
375: WHERE civb.content_item_id = p_content_item_id
376: AND civb.citem_version_id = civtl.citem_version_id
377: AND language = p_language;