APPS.ISC_FS_TASK_SETUP SQL Statements

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

Line: 16

  insert into ISC_FS_BREAK_FIX_TASKS
  ( task_type_id
  , created_by
  , creation_date
  , last_updated_by
  , last_update_date
  , last_update_login
  , enabled
  )
  select
    task_type_id
  , fnd_global.user_id
  , sysdate
  , fnd_global.user_id
  , sysdate
  , fnd_global.login_id
  , 'N'
  from JTF_TASK_TYPES_B jtfb
  where jtfb.rule='DISPATCH'
  and jtfb.task_type_id NOT in ( select task_type_id
                                 from ISC_FS_BREAK_FIX_TASKS
                               );