APPS.HR_DM_CLEANUP SQL Statements

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

Line: 58

  SELECT tbl.loader_name,
         tbl.loader_conc_program,
         tbl.loader_config_file,
         tbl.loader_application,
         lp.parameter1, lp.parameter2,
         lp.parameter3, lp.parameter4,
         lp.parameter4, lp.parameter6,
         lp.parameter5, lp.parameter8,
         lp.parameter7, lp.parameter10,
         lp.application_id
  FROM hr_dm_tables tbl,
       hr_dm_loader_params lp,
       hr_dm_phase_items pi
  WHERE (pi.phase_item_id = p_phase_item_id)
    AND (pi.loader_params_id = lp.loader_params_id)
    AND (lp.table_id = tbl.table_id);

Line: 143

hr_dm_master.insert_request(p_phase => 'C',
                            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: 250

  SELECT pi.phase_item_id, pi.loader_name, pi.status
    FROM hr_dm_phase_items pi,
         hr_dm_tables tbl
    WHERE (pi.status = 'NS')
      AND (pi.phase_id = l_phase_id)
      AND (pi.loader_name = tbl.loader_name);

Line: 259

  SELECT request_id
    FROM hr_dm_migration_requests
    WHERE phase_item_id = l_phase_item_id;

Line: 265

  SELECT business_group_id
    FROM hr_dm_migrations
    WHERE migration_id = p_migration_id;

Line: 338

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

Line: 344

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

Line: 373

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

Line: 424

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

Line: 433

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

Line: 441

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