APPS.BEN_DM_GEN_MASTER SQL Statements

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

Line: 42

select tbl.table_id
      ,tbl.table_name
      ,tbl.table_alias
      ,phs.phase_id
      ,itm.phase_item_id
from ben_dm_tables tbl,
     ben_dm_phase_items itm,
     ben_dm_phases  phs
where phs.migration_id = p_migration_id
and   phs.phase_name   = 'G'
and   phs.phase_id     = itm.phase_id
and   mod(itm.phase_item_id,l_no_of_threads) + 1 = p_process_number
and   itm.status       = 'NS'
and   itm.table_name   = tbl.table_name
and   rownum < 2;

Line: 122

   ben_dm_utility.update_phase_items(p_new_status => 'S',
                                       p_id => l_csr_get_table_rec.phase_item_id);

Line: 172

   update ben_dm_tables
   set last_generated_date = sysdate,
       generator_version   = l_generator_version
   where table_id = l_csr_get_table_rec.table_id;

Line: 178

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

Line: 224

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

Line: 227

     ben_dm_utility.update_phases(p_new_status => 'E',
                                 p_id => l_phase_id);

Line: 245

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

Line: 248

     ben_dm_utility.update_phases(p_new_status => 'E',
                                 p_id => l_phase_id);

Line: 260

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

Line: 289

select tbl.short_name
from ben_dm_tables tbl,
     ben_dm_table_order  dto
where tbl.table_id     = dto.table_id
order by   dto.table_order ;

Line: 297

select dif.input_file_id
      ,dif.source_business_group_name
      ,dif.source_person_id
      ,dif.source_national_identifier
      ,dif.target_business_group_name
      ,dif.group_order
  from ben_dm_input_file dif
where  dif.input_file_id= p_input_file_id ;

Line: 307

select itm.phase_item_id
      ,itm.input_file_id
  from ben_dm_phase_items itm,
       ben_dm_phases  phs
where  phs.migration_id = p_migration_id
  and  phs.phase_name   = 'DP'
  and  phs.phase_id     = itm.phase_id
  and  mod(itm.phase_item_id,l_no_of_threads) + 1 = p_process_number
  and  itm.status       = 'NS' ;

Line: 318

select business_group_id
from   per_business_groups
where name =  l_name ;

Line: 415

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

Line: 462

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

Line: 487

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

Line: 497

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

Line: 524

select tbl.short_name
  from ben_dm_tables tbl,
       ben_dm_table_order  dto
where tbl.table_id     = dto.table_id
order by  dto.table_order ;

Line: 531

select  itm.phase_item_id
       ,itm.phase_id
       ,itm.group_order
  from ben_dm_phase_items itm,
       ben_dm_phases  phs
 where phs.migration_id = p_migration_id
   and phs.phase_id     = itm.phase_id
   and phs.phase_name   = 'UP'
   and mod(itm.phase_item_id,l_no_of_threads) + 1 = p_process_number
   and itm.status       = 'NS';

Line: 543

select dif.target_business_group_name
      ,dif.group_order
  from ben_dm_input_file dif
where  dif.group_order  = l_group_order
  and  dif. status      = 'NS'
  order by dif.group_order;

Line: 552

select business_group_id
  from per_business_groups
 where name =  l_name ;

Line: 641

     ben_dm_utility.update_phase_items(p_new_status => 'S',
                                       p_id => l_phase_rec.phase_item_id);

Line: 749

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

Line: 753

    ben_dm_data_util.g_pk_maping_tbl.delete ;

Line: 769

  ben_dm_data_util.g_fk_maping_tbl.delete ;

Line: 782

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

Line: 785

         ben_dm_utility.update_phases(p_new_status => 'E',
                                     p_id => l_phase_id);

Line: 795

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