APPS.OZF_ACTIVITY_DENORM_PVT SQL Statements

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

Line: 105

  SELECT application_id
    FROM fnd_application
   WHERE application_short_name='OZF';

Line: 110

  SELECT concurrent_program_id
   FROM fnd_concurrent_programs
  WHERE application_id = l_app_id
    AND concurrent_program_name = 'OZFOEPD';

Line: 116

  SELECT max(actual_completion_date)
    FROM fnd_concurrent_requests
   WHERE program_application_id = l_app_id
     AND concurrent_program_id =  l_conc_program_id
     --16-APR-2007 kdass added for bug 5975207
     AND (argument2 = NVL(p_offer_id,0) OR argument2 IS NULL)
     AND status_code = 'C'
     AND phase_code = 'C';