APPS.ZPB_AW_STATUS SQL Statements

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

Line: 85

    SELECT status_sql_id, status_sql, dimension_name, hierarchy_name
       FROM zpb_status_sql
       WHERE (query_path = p_query)
       ORDER BY DIMENSION_NAME, ROW_NUM;

Line: 283

    SELECT status_sql_id, status_sql, dimension_name, hierarchy_name
       FROM zpb_status_sql
       WHERE (query_path = p_query)
       ORDER BY DIMENSION_NAME, ROW_NUM;

Line: 366

         select distinct DIMENSION_NAME
            from ZPB_STATUS_SQL
            where (query_path = p_query);

Line: 414

    SELECT status_sql
       FROM zpb_status_sql
       WHERE (query_path = p_query)
       AND DIMENSION_NAME = p_dimension
       ORDER BY ROW_NUM;

Line: 451

   l_sql_statement := 'select count(*) from (';