APPS.BSC_BIA_WRAPPER SQL Statements

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

Line: 306

      SELECT DISTINCT kt.indicator
      FROM bsc_kpi_data_tables kt, bsc_db_tables_cols tc, bsc_db_measure_cols_vl m
      WHERE kt.table_name = tc.table_name AND
            tc.column_type = p1 AND
            NVL(tc.source, p2) = p3 AND
            tc.column_name = m.measure_col AND
            NVL(m.projection_id, p4) <> p5;

Line: 323

        g_projection_kpis.delete;

Line: 542

    SELECT DISTINCT INDICATOR
    FROM   BSC_KPI_DATA_TABLES
    WHERE  MV_NAME = p_mv;

Line: 548

    SELECT DISTINCT T.INDICATOR
    FROM   BSC_KPI_DATA_TABLES T, BSC_DB_TABLES_RELS R
    WHERE  T.TABLE_NAME    = R.TABLE_NAME
    AND    R.RELATION_TYPE = 1
    AND    BSC_BIA_WRAPPER.Get_Sum_Table_MV_Name(SOURCE_TABLE_NAME) = p_mv;