[Home] [Help]
81: 70.15 23-NOV-94 RFINE G1725 Suppressed index on business_group_id
82: 70.16 29-NOV-94 DSAXBY Altered the way payroll actions and
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
239: 115.23 01-JUL-03 tvankayl Procedure DELETE_PAY_MISC modified to
240: delete records from PAY_CUSTOM_RESTRICTIONS_TL
241: before deleting from PAY_CUSTOMIZED_RESTRICTIONS
242: 115.24 15-JUL-03 scchakra Bug 2982582. Added deletion of
243: pay_monetary_units_tl in
244: delete_assign_low_detail.
245: 115.25 28-AUG-03 nbristow Added procedure delete_retro_details.
246: 115.26 sep-2003 mbocutt Ex-person security enhancements. Remove
247: references to per_person_list_changes.
535: )
536: );
537: --
538: hr_utility.set_location('hr_delete.delete_assign_low_detail',3);
539: DELETE FROM pay_monetary_units_tl montl
540: WHERE EXISTS ( SELECT ''
541: FROM pay_monetary_units mon
542: WHERE montl.monetary_unit_id = mon.monetary_unit_id
543: AND mon.business_group_id = p_business_group_id
537: --
538: hr_utility.set_location('hr_delete.delete_assign_low_detail',3);
539: DELETE FROM pay_monetary_units_tl montl
540: WHERE EXISTS ( SELECT ''
541: FROM pay_monetary_units mon
542: WHERE montl.monetary_unit_id = mon.monetary_unit_id
543: AND mon.business_group_id = p_business_group_id
544: );
545: --
542: WHERE montl.monetary_unit_id = mon.monetary_unit_id
543: AND mon.business_group_id = p_business_group_id
544: );
545: --
546: DELETE FROM pay_monetary_units mon
547: WHERE mon.business_group_id = p_business_group_id;
548: --
549: hr_utility.set_location('hr_delete.delete_assign_low_detail',5);
550: DELETE FROM pay_process_events ppe