APPS.BEN_DM_BUSINESS SQL Statements

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

Line: 40

select 'x'
  from fnd_concurrent_requests req,
       fnd_concurrent_programs prog
 where prog.concurrent_program_name in ('BENDMSD','BENDMSU')
   and req.concurrent_program_id = prog.concurrent_program_id
   and req.request_id <> fnd_global.conc_request_id
   and req.phase_code <> 'C';

Line: 79

  update ben_dm_migrations
     set status =decode(status,'E','A','C')
   where migration_id <>  r_migration_data.migration_id
     and status <> 'C';

Line: 135

  SELECT status
    FROM ben_dm_migrations
    WHERE (migration_id = r_migration_data.migration_id);

Line: 215

  SELECT request_id
    FROM ben_dm_migration_requests
    WHERE (migration_id = r_migration_data.migration_id)
      AND (master_slave <> 'M');

Line: 307

select 'x'
  from fnd_concurrent_requests req,
       fnd_concurrent_programs prog
 where prog.concurrent_program_name in ('BENDMSD','BENDMSU')
   and req.concurrent_program_id = prog.concurrent_program_id
   and req.request_id <> fnd_global.conc_request_id
   and req.phase_code <> 'C';

Line: 347

  update ben_dm_migrations
     set status =decode(status,'E','A','C')
   where migration_id <>  r_migration_data.migration_id
     and status <> 'C';

Line: 410

  SELECT status
    FROM ben_dm_migrations
    WHERE (migration_id = r_migration_data.migration_id);

Line: 484

  SELECT status
    FROM ben_dm_migrations
    WHERE (migration_id = r_migration_data.migration_id);

Line: 567

  SELECT MAX(effective_date)
    FROM ben_dm_migrations
    WHERE (status = 'C');