633: -- We need to delete the database items for the deleted element
634: hrdyndbi.delete_element_type_dict (p_rec.element_type_id);
635: -- -- We need to delete any payroll frequency rules for the element
636: --
637: delete from pay_ele_payroll_freq_rules
638: where element_type_id = p_rec.element_type_id;
639: --
640: -- Delete the child retro component usages.
641: --
652: Elsif p_datetrack_mode = hr_api.g_delete Then
653: -- -- We need to remove any payroll frequency rules starting after the new end
654: -- date
655: --
656: delete from pay_ele_payroll_freq_rules
657: where element_type_id = p_rec.element_type_id
658: and start_date > p_effective_date;
659: --
660: End If;