APPS.BEN_FORFEITURE_CONCURRENT dependencies on DUAL

Line 1395: from sys.dual;

1391: hr_utility.set_location('not skip...Inserting Ben_person_actions',28);
1392: l_actn := 'Inserting Ben_person_actions...';
1393: select ben_person_actions_s.nextval
1394: into l_person_action_id
1395: from sys.dual;
1396:
1397: insert into ben_person_actions
1398: (person_action_id,
1399: person_id,

Line 1432: from sys.dual;

1428: -- Select next sequence number for the range
1429: --
1430: select ben_batch_ranges_s.nextval
1431: into l_range_id
1432: from sys.dual;
1433:
1434: insert into ben_batch_ranges
1435: (range_id,
1436: benefit_action_id,

Line 1465: from sys.dual;

1461: hr_utility.set_location('Inserting Final Ben_batch_ranges',38);
1462:
1463: select ben_batch_ranges_s.nextval
1464: into l_range_id
1465: from sys.dual;
1466:
1467: insert into ben_batch_ranges
1468: (range_id,
1469: benefit_action_id,

Line 1765: -- Future enhancements for individual person processing goes here.

1761:
1762: Delete from ben_batch_ranges
1763: Where benefit_action_id = l_benefit_action_id;
1764: --
1765: -- Future enhancements for individual person processing goes here.
1766: --
1767: Else
1768: --
1769: hr_utility.set_location('p_benefit_action_id is not null',30);