APPS.HR_DM_DOWNLOAD SQL Statements

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

Line: 69

  select mr.phase_item_id,
         mr.range_id,
         mr.starting_process_sequence,
         mr.ending_process_sequence,
         mr.status,
         tbl.table_name,
         tbl.short_name,
         pi_dn.batch_id
    from hr_dm_phase_items pi_dn,
         hr_dm_tables tbl,
         hr_dm_migration_ranges mr,
         hr_dm_phase_items pi_rg
    where pi_rg.phase_id = l_range_phase_id
    and  pi_rg.phase_item_id = mr.phase_item_id
    and  mr.status = 'NS'
    and  mod(mr.range_id,l_no_of_threads) + 1 = p_process_number
    and  pi_rg.table_name = tbl.table_name
    and  pi_dn.phase_id = l_download_phase_id
    and  pi_dn.group_id = pi_rg.group_id
    and  pi_dn.status in ('NS','S', 'E');

Line: 92

  select business_group_id,
         migration_type
  from hr_dm_migrations
  where migration_id = p_migration_id;

Line: 173

    hr_dm_utility.update_migration_ranges(p_new_status => 'S',
                                         p_id => l_table_range_rec.range_id);

Line: 219

    update hr_dm_migration_ranges
    set row_count = l_no_of_rec_downloaded
    where range_id = l_table_range_rec.range_id;

Line: 224

    hr_dm_utility.update_migration_ranges(p_new_status => 'C',
                                          p_id => l_table_range_rec.range_id);

Line: 260

    hr_dm_utility.update_migration_ranges(p_new_status => 'E',
                                          p_id => l_range_id);