492: l_actn := 'Inserting Ben_batch_ranges.......';
493: hr_utility.set_location('Inserting Ben_batch_ranges',32);
494: -- Select next sequence number for the range
495: --
496: select ben_batch_ranges_s.nextval
497: into l_range_id
498: from sys.dual;
499:
500: insert into ben_batch_ranges
524: If (l_num_row <> 0) then
525: l_actn := 'Inserting Final Ben_batch_ranges...';
526: hr_utility.set_location('Inserting Final Ben_batch_ranges',38);
527:
528: select ben_batch_ranges_s.nextval
529: into l_range_id
530: from sys.dual;
531:
532: insert into ben_batch_ranges