APPS.HR_DM_RANGE SQL Statements

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

Line: 66

  SELECT pi.phase_item_id, pi.table_name, pi.status, tbl.short_name
    FROM hr_dm_phase_items pi,
         hr_dm_tables tbl
    WHERE  pi.status = 'NS'
      AND  mod(pi.phase_item_id,l_no_of_threads) + 1 = p_process_number
      AND  pi.phase_id = l_phase_id
      AND  pi.table_name = tbl.table_name;

Line: 75

  SELECT business_group_id, migration_type
    FROM hr_dm_migrations
    WHERE migration_id = p_migration_id;

Line: 130

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

Line: 152

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

Line: 181

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