APPS.ICX_CAT_STORE_ASSIGNMENT_PKG SQL Statements

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

Line: 13

    SELECT
      DISTINCT stores.store_id
    FROM
      icx_cat_store_contents contents,
      icx_Cat_shop_stores_b stores
    WHERE
      contents.content_type = p_contentType AND
      contents.content_id = p_contentId  AND
      contents.store_id = stores.store_id;

Line: 54

    SELECT
      DISTINCT name
    FROM
      icx_cat_store_contents contents,
      icx_Cat_shop_stores_vl stores
    WHERE
      contents.content_type = p_contentType AND
      contents.content_id = p_contentId  AND
      contents.store_id = stores.store_id;

Line: 78

    SELECT message_text
    INTO   xMultipleMsg
    FROM   fnd_new_messages
    WHERE  message_name = 'ICX_POR_MULTIPLE'
       AND language_code = USERENV('LANG');