APPS.BIS_PMF_PORTLET_UTIL SQL Statements

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

Line: 351

  l_stmt := 'SELECT ' || p_call || ' as value FROM dual';

Line: 428

  SELECT count(1)
  FROM bis_pmf_populate_portlet bpp
  WHERE bpp.PLUG_ID = p_plug_id;

Line: 510

    SELECT COUNT(1)
    FROM bis_user_ind_selections
    WHERE plug_id = p_plug_id
    AND   USER_ID = p_user_id;

Line: 516

    SELECT USER_ID
    FROM ICX_PORTLET_CUSTOMIZATIONS
    WHERE PLUG_ID = p_plug_id;

Line: 558

    SELECT distinct DECODE(b.user_id, NULL, 0, 1), e.responsibility_id
  FROM
    fnd_user_resp_groups b
    ,bisbv_target_levels d
    ,bis_indicator_resps e
  WHERE
        b.user_id = p_cur_user_id
  AND   d.target_level_id = p_target_level_id
  AND   e.target_level_id = d.target_level_id
  AND   b.responsibility_id = e.responsibility_id
  AND   b.start_date <= sysdate
  AND   (b.end_date IS NULL or b.end_date >= sysdate);

Line: 640

    SELECT COUNT(1)
    FROM
      bis_user_ind_selections bu
     ,ICX_PORTLET_CUSTOMIZATIONS ipc
    WHERE ipc.plug_id = p_plug_id
    AND   bu.plug_id = ipc.plug_id
    AND   bu.user_id = ipc.user_id;

Line: 649

    SELECT USER_ID
    FROM ICX_PORTLET_CUSTOMIZATIONS
    WHERE PLUG_ID = p_plug_id;

Line: 690

  DELETE
  FROM BIS_USER_IND_SELECTIONS
  WHERE  PLUG_ID = p_plug_id
  AND TARGET_LEVEL_ID = FND_API.G_MISS_NUM;

Line: 696

  DELETE
  FROM BIS_USER_IND_SELECTIONS
  WHERE  PLUG_ID = p_plug_id
  AND TARGET_LEVEL_ID NOT IN
    ( SELECT TARGET_LEVEL_ID
      FROM BIS_TARGET_LEVELS
    );

Line: 1053

    SELECT attribute7, attribute14
    FROM ak_region_items
    WHERE
        region_code = p_region_code
    AND attribute_code = p_attribute_code;

Line: 1107

  l_sql := ' SELECT parent_id FROM '|| p_view_name || ' WHERE id= :bind_id ';

Line: 1219

    l_sql := ' SELECT value FROM '|| p_view_name || ' WHERE id= :bind_id and rownum < 2 GROUP BY value ';

Line: 1270

    SELECT column_name FROM user_tab_columns
    WHERE table_name = l_view_name;

Line: 1277

  BIS_PMF_GET_DIMLEVELS_PVT.GET_DIMLEVEL_SELECT_STRING(
     p_DimLevelName         => p_dim_level_sname
    ,x_Select_String        => l_sql
    ,x_table_name           => l_view_name
    ,x_id_name              => l_id_name
    ,x_value_name           => l_value_name
    ,x_time_level           => l_time_level
    ,x_return_status        => l_return_status
    ,x_msg_count            => l_msg_count
    ,x_msg_data             => l_msg_data
  );

Line: 1418

  SELECT application_name
  FROM fnd_application_vl app
  WHERE app.application_short_name = upper(l_code);

Line: 1479

  SELECT application_id
  FROM fnd_application_vl app
  WHERE app.application_short_name = upper(l_code);