APPS.FEM_MV_REFRESH_PVT SQL Statements

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

Line: 54

  SELECT 'Y'
  FROM   user_objects
  WHERE  object_name =  c_object_name
  AND    object_type =  c_object_type ;

Line: 106

     USING ( SELECT p_mv_name                mv_name               ,
                    p_base_table_name        base_table_name       ,
                    p_refresh_group_sequence refresh_group_sequence
             FROM   dual ) t
     ON ( s.mv_name = t.mv_name )
     WHEN MATCHED THEN
       UPDATE SET s.refresh_group_sequence =
                  NVL(t.refresh_group_sequence, s.refresh_group_sequence),
                  s.base_table_name        = t.base_table_name           ,
                  s.last_updated_by        = g_user_id                   ,
                  s.last_update_date       = g_sys_date                  ,
                  s.last_update_login      = g_user_id
     WHEN NOT MATCHED THEN
       INSERT (   s.mv_name               ,
                  s.refresh_group_sequence,
                  s.base_table_name       ,
                  s.created_by            ,
                  s.creation_date         ,
                  s.last_updated_by       ,
                  s.last_update_date      ,
                  s.last_update_login
              )
              VALUES
              (   t.mv_name                        ,
                  NVL(t.refresh_group_sequence, 10),
                  t.base_table_name                ,
                  g_user_id                        ,
                  g_sys_date                       ,
                  g_user_id                        ,
                  g_sys_date                       ,
                  g_user_id
              ) ;

Line: 202

  DELETE fem_mv_refresh_objects
  WHERE  mv_name = p_mv_name ;

Line: 355

    SELECT mv_name, refresh_group_sequence
    FROM   fem_mv_refresh_objects
    WHERE  base_table_name = NVL(p_base_table_name, base_table_name)
    ORDER BY refresh_group_sequence
  )
  LOOP

    IF l_last_refresh_group_sequence IS NULL THEN

      l_mv_list := l_mv_rec.mv_name ;