APPS.FND_WF_STANDARD SQL Statements

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

Line: 101

  select avg(fr1.actual_completion_date - fr1.actual_start_date)
  from fnd_concurrent_requests fr1, fnd_concurrent_requests fr2
  where fr2.request_id = c_reqID
  and fr1.concurrent_program_id = fr2.concurrent_program_id
  and fr1.program_application_id = fr2.program_application_id
  and fr1.actual_start_date is not null
  and fr1.actual_completion_date is not null;