APPS.FND_OAM_DEBUG SQL Statements

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

Line: 145

      SELECT value
         INTO l_tmp_dir
         FROM V$PARAMETER
         WHERE name = 'utl_file_dir';

Line: 166

         SELECT substr(round(to_char(systimestamp, 'FF'),-5),1,4)
            INTO l_suffix
            FROM DUAL;

Line: 322

         SELECT systimestamp
            INTO l_now
            FROM DUAL;

Line: 327

         SELECT systimestamp
            INTO l_now
            FROM DUAL;