eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_DELETE dependencies on PER_SPECIAL_INFO_TYPE_USAGES

Line 87: 70.19 14-JUN-95 NLBARLOW Delete from per_special_info_type_usages

83: assignment actions are rolled back
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!!

Line 1606: DELETE FROM per_special_info_type_usages situ

1602: open csr_get_spec_inf_type(p_business_group_id);
1603: fetch csr_get_spec_inf_type into l_exists;
1604: if csr_get_spec_inf_type%found then
1605: --
1606: DELETE FROM per_special_info_type_usages situ
1607: WHERE situ.special_information_type_id =
1608: (SELECT sit.special_information_type_id
1609: FROM per_special_info_types sit
1610: WHERE sit.special_information_type_id = situ.special_information_type_id