APPS.PO_IP_INTEGRATION_GRP SQL Statements

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

Line: 42

  SELECT shopping_category_id
  INTO x_ip_category_id
  FROM ICX_CAT_PURCHASING_CAT_MAP_V
  WHERE po_category_id = p_po_category_id;

Line: 85

  SELECT po_category_id
  INTO x_po_category_id
  FROM ICX_CAT_SHOPPING_CAT_MAP_V
  WHERE shopping_category_id = p_ip_category_id;

Line: 130

  SELECT category_name
  INTO   x_shopping_category_name
  FROM   ICX_CAT_CATEGORIES_V
  WHERE  rt_category_id = p_ip_category_id
  AND    language = p_language;