[Home] [Help]
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
90: and values. Was causing full table
376: IS
377: begin
378: --
379: hr_utility.set_location('hr_delete.delete_mag_structure',1);
380: DELETE FROM pay_magnetic_records mr
381: WHERE EXISTS ( SELECT ''
382: FROM ff_formulas_f ff
383: WHERE ff.formula_id = mr.formula_id
384: AND ff.business_group_id = p_business_group_id);