APPS.FND_TXK_TECH_INT_PKG SQL Statements

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

Line: 108

       select substr(preference_name,18) into l_old_file_id
       from fnd_user_preferences
       where PREFERENCE_NAME like 'TXK_BPEL_FILE_ID_%'
       and PREFERENCE_VALUE = 'EbsBpelGlobal.properties'
       and USER_NAME = '#INTERNAL' ;

Line: 116

        delete from fnd_lobs where file_id = l_old_file_id;