APPS.BSC_BIS_PMDLDR_DELDATA SQL Statements

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

Line: 50

   G_TABNAME_TABLE.delete;

Line: 88

   G_KPI_TABLE.delete;

Line: 94

   G_TABNAME_TABLE.delete;

Line: 99

 PROCEDURE SELECT_INDICATOR(p_ind number) IS
 BEGIN
   G_KPI_TABLE_SIZE := G_KPI_TABLE_SIZE + 1;

Line: 116

   ' SELECT DISTINCT TABLE_NAME ' ||
   ' FROM BSC_KPI_DATA_TABLES_V ' ||
   ' WHERE (' ||  p_stmtWhereInIndics || ' ) ';

Line: 151

   ' SELECT TABLE_NAME ' ||
   ' FROM BSC_KPI_DATA_TABLES_V ' ||
   ' WHERE INDICATOR IN ( ' ||
   ' SELECT INDICATOR ' ||
   ' FROM BSC_KPI_DATA_TABLES_V ' ||
   ' WHERE ' ||  p_stmtTempWhereInTables ||
   ' ) ' ||
   ' AND TABLE_NAME IS NOT NULL' ||
   ' MINUS ' ||  l_stmtWhereNotInTables;

Line: 197

   ' SELECT * from ( SELECT TABLE_NAME ' ||
   ' FROM BSC_DB_TABLES_RELS WHERE ' || p_stmtTempWhereInSrcTables ||
   ' UNION ' ||
   ' SELECT SOURCE_TABLE_NAME ' ||
   ' FROM BSC_DB_TABLES_RELS WHERE ' || p_stmtTempWhereInTables || ' ) ' ||
   ' MINUS ' || l_stmtWhereNotInTables;

Line: 242

       'SELECT DISTINCT INDICATOR ' ||
       ' FROM BSC_KPI_DATA_TABLES_V ' ||
       ' WHERE TABLE_NAME IN ( ' || p_stmtWhereInTables || ' ) ' ||
       --' WHERE ( ' || p_stmtWhereInTables || ' ) ' ||
       ' MINUS ' || l_stmtNotWhereInIndics ;