APPS.BSC_CAUSE_EFFECT_UI_WRAPPER SQL Statements

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

Line: 120

  BSC_CAUSE_EFFECT_REL_PUB.Delete_All_Cause_Effect_Rels(l_commit
                               ,p_indicator
                               ,p_level
                               ,x_return_status
                               ,x_msg_count
                               ,x_msg_data);

Line: 205

    SELECT count(*)
    INTO l_count
    FROM bsc_sys_datasets_b
    WHERE measure_id1 = (
       SELECT measure_id
       FROM bsc_sys_measures
       WHERE short_name = p_measure_short_name);

Line: 229

    SELECT dataset_id INTO l_dataset_id
    FROM bsc_sys_datasets_b
    WHERE measure_id1 = (
        SELECT measure_id
        FROM bsc_sys_measures
        WHERE short_name = p_measure_short_name);

Line: 374

       l_sql := 'SELECT name FROM bsc_kpis_vl WHERE indicator = :i';

Line: 376

       l_sql := 'SELECT name FROM bsc_sys_datasets_vl'||
                ' WHERE measure_id1 = (SELECT measure_id FROM bsc_sys_measures'||
                ' WHERE short_name = :i)';

Line: 442

      SELECT short_name INTO l_measure_short_name
      FROM bsc_sys_measures
      WHERE measure_id = (SELECT measure_id1 FROM bsc_sys_datasets_b WHERE dataset_id = p_indicator);

Line: 554

              l_sql := 'SELECT attribute2'||
                       ' FROM ak_region_items'||
                       ' WHERE region_code = :1'||
                       ' AND attribute1 IN (''DIMENSION LEVEL'', ''DIM LEVEL SINGLE VALUE'','||
                       ' ''VIEW BY PARAMETER'')'||
                       ' ORDER BY display_sequence';

Line: 733

      SELECT
          function_id
      FROM
          fnd_form_functions
      WHERE
          function_name = p_function_name;

Line: 743

      SELECT
          a.menu_id
      FROM
          fnd_responsibility_vl a,
          fnd_user_resp_groups b
      WHERE
          b.user_id = p_user_id AND
          a.version = 'W' AND
          b.responsibility_id = a.responsibility_id AND
          b.start_date <= SYSDATE AND
          (b.end_date IS NULL OR b.end_date >= SYSDATE) AND
          a.start_date <= sysdate AND
          (a.end_date IS NULL OR a.end_date >= SYSDATE);