DBA Data[Home] [Help]

APPS.HR_DELETE dependencies on PER_PERSON_TYPES

Line 88: 70.20 26-JUL-95 Kev Koh Added deletions for per_person_types

84: following change in rollback rules.
85: 70.17 16-FEB-95 DSAXBY Delete from pay_monetary_units.
86: 70.18 24-FEB-95 NBRISTOW Delete from pay_magnetic_records.
87: 70.19 14-JUN-95 NLBARLOW Delete from per_special_info_type_usages
88: 70.20 26-JUL-95 Kev Koh Added deletions for per_person_types
89: 70.21 23-AUG-95 DSAXBY Improved deletion from element entries
90: and values. Was causing full table
91: scans on both these tables!!
92: 70.22 24-AUG-95 Kev Koh Improved deletion from link input

Line 1388: DELETE FROM per_person_types

1384: end if;
1385: close csr_get_person;
1386: hr_utility.set_location(l_proc,120);
1387: --
1388: DELETE FROM per_person_types
1389: WHERE business_group_id = p_business_group_id;
1390: hr_utility.set_location('Leaving: '||l_proc,130);
1391: --
1392: end delete_person_direct;