APPS.IGF_AP_LOADER_LAUNCH_PKG SQL Statements

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

Line: 75

   SELECT fcr.argument1
   FROM   fnd_concurrent_requests fcr, fnd_concurrent_programs ucpn
   WHERE  fcr.program_application_id = ucpn.application_id
     AND  fcr.concurrent_program_id  = ucpn.concurrent_program_id
     AND  fcr.phase_code = 'R'
     AND  ucpn.concurrent_program_name = 'IGFAPX06'
     AND  ucpn.application_id = 8405;

Line: 135

  SELECT 'X'
  FROM   igf_lookups_view
  WHERE  lookup_type = 'IGF_AP_ISIR_MESSAGE_CLASS'
    AND  lookup_code = UPPER(cp_msg_class)
    AND  enabled_flag = 'Y';