APPS.PER_RI_PRE_DATAPUMP SQL Statements

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

Line: 44

    select phase_code,
           status_code
    from   fnd_concurrent_requests fnd
    where  fnd.request_id = c_request_id;

Line: 114

     select distinct module_name
       from hr_pump_batch_lines lines,
            hr_api_modules api
      where lines.batch_id = p_batch_id
        and lines.api_module_id = api.api_module_id ;