DBA Data[Home] [Help]

APPS.IBC_CITEM_WORKFLOW_PVT dependencies on IBC_CITEM_VERSIONS_TL

Line 348: FROM ibc_citem_versions_tl

344: AND civer.content_item_id = citem.content_item_id;
345:
346: CURSOR c_citem_name(p_citem_ver_id NUMBER) IS
347: SELECT content_item_name
348: FROM ibc_citem_versions_tl
349: WHERE citem_version_id = p_citem_ver_id
350: AND language = p_language;
351:
352: CURSOR c_user_name(p_user_id IN NUMBER) IS

Line 1057: FROM ibc_citem_versions_tl

1053: WHERE ci.content_item_id = civ.content_item_id
1054: AND civ.citem_version_id = p_citem_version_id;
1055: CURSOR c_citem_name(p_citem_ver_id NUMBER, p_language VARCHAR2) IS
1056: SELECT content_item_name
1057: FROM ibc_citem_versions_tl
1058: WHERE citem_version_id = p_citem_ver_id
1059: AND language = p_language;
1060:
1061: CURSOR c_directory(p_content_item_id NUMBER) IS

Line 1893: FROM ibc_citem_versions_tl

1889: AND CIVER.content_item_id = CITEM.content_item_id;
1890:
1891: CURSOR c_citem_name(p_citem_ver_id NUMBER) IS
1892: SELECT content_item_name
1893: FROM ibc_citem_versions_tl
1894: WHERE citem_version_id = p_citem_ver_id
1895: AND language = p_language;
1896:
1897: CURSOR c_user_name(p_user_id IN NUMBER) IS