APPS.HR_DM_UPLOAD SQL Statements

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

Line: 43

  hr_dm_master.insert_request(p_phase         => p_current_phase,
                              p_request_id    => l_request_id,
                              p_master_slave  => 'S',
                              p_migration_id  => p_migration_id,
                              p_phase_id      => p_phase_id,
                              p_phase_item_id => p_phase_item_id);

Line: 147

  SELECT pi.phase_item_id,
         pi.status,
         pi.batch_id
  FROM  hr_dm_phase_items pi,
        hr_dm_application_groups apg
  WHERE pi.status = 'NS'
  AND pi.phase_id = l_phase_id
  AND pi.group_id = apg.group_id
  ORDER BY apg.group_order;

Line: 160

  SELECT req.request_id,
         pi.batch_id
  FROM hr_dm_migration_requests req,
       hr_dm_phase_items pi
  WHERE pi.phase_item_id = l_phase_item_id
  and   pi.phase_item_id = req.phase_item_id;

Line: 172

  SELECT 1
  FROM fnd_concurrent_requests
  WHERE parent_request_id = p_request_id
  AND   phase_code <> 'C';

Line: 179

  SELECT request_id
  FROM fnd_concurrent_requests
  WHERE (parent_request_id = p_request_id OR
         request_id = p_request_id)
  AND   status_code <> 'C';

Line: 189

  SELECT batch_status
  FROM hr_pump_batch_headers
  WHERE batch_id = l_batch_id;

Line: 306

      hr_dm_utility.update_phase_items(p_new_status => 'C',
                                       p_id => l_phase_item_id);

Line: 358

      hr_dm_utility.update_phase_items(p_new_status => 'S',
                                       p_id => l_phase_item_id);

Line: 407

    hr_dm_utility.update_phase_items(p_new_status => 'E',
                                     p_id => l_phase_item_id);

Line: 419

    hr_dm_utility.update_phase_items(p_new_status => 'E',
                                     p_id => l_phase_item_id);

Line: 451

  SELECT source_database_instance
    FROM hr_dm_migrations
    WHERE status NOT IN ('F', 'A');