DBA Data[Home] [Help]

APPS.IBC_UTILITIES_GRP dependencies on IBC_CITEM_VERSIONS_TL

Line 117: FROM ibc_citem_versions_tl

113:
114: IF p_mime_type IS NULL THEN
115: SELECT default_rendition_mime_type
116: INTO l_mime_type
117: FROM ibc_citem_versions_tl
118: WHERE citem_version_id = l_citem_ver_id
119: AND language = l_language;
120: ELSE
121: l_mime_type := p_mime_type;

Line 231: ibc_citem_versions_tl civtl

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;
235:

Line 374: ibc_citem_versions_tl civtl

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;
378: