APPS.IBC_UTILITIES_GRP SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 67

 	SELECT file_id
   	FROM IBC_RENDITIONS
 	 WHERE citem_version_id = p_civid
     AND language = p_language
 	   AND mime_type = p_mime_type;

Line: 75

  SELECT live_citem_version_id
    FROM IBC_CONTENT_ITEMS
   WHERE content_item_id = p_content_item_id;

Line: 115

        SELECT default_rendition_mime_type
          INTO l_mime_type
          FROM ibc_citem_versions_tl
         WHERE citem_version_id = l_citem_ver_id
           AND language = l_language;

Line: 206

  IS SELECT directory_path
       FROM ibc_directory_nodes_b
      WHERE directory_node_id = p_directory_node_id;

Line: 216

    SELECT content_item_id
     FROM ibc_citem_permissions_v citems,
          ibc_directory_nodes_b   dirnodes
    WHERE citems.permission_code IN ('ALL_ALLOWED', p_permission_code)
      AND citems.user_id = p_user_id
      AND citems.security_flag = p_security_flag
      AND citems.directory_node_id = dirnodes.directory_node_id
      AND dirnodes.directory_path LIKE NVL(p_path_pattern, '%')
      AND dirnodes.node_type = 'WD';

Line: 229

    SELECT MAX(civtl.content_item_name)
      FROM ibc_citem_versions_b civb,
           ibc_citem_versions_tl civtl
     WHERE civb.content_item_id = p_content_item_id
       AND civb.citem_version_id = civtl.citem_version_id
       AND language = p_language;

Line: 363

    SELECT stlshts.content_item_id
      FROM ibc_content_items citems,
           ibc_stylesheets stlshts
     WHERE citems.content_type_code = stlshts.content_type_code
       AND citems.content_item_id = p_content_item_id;

Line: 372

    SELECT MAX(civtl.content_item_name)
      FROM ibc_citem_versions_b civb,
           ibc_citem_versions_tl civtl
     WHERE civb.content_item_id = p_content_item_id
       AND civb.citem_version_id = civtl.citem_version_id
       AND language = p_language;