DBA Data[Home] [Help]

APPS.PAY_ETP_DEL_ND dependencies on PAY_ELE_PAYROLL_FREQ_RULES

Line 637: delete from pay_ele_payroll_freq_rules

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: --

Line 656: delete from pay_ele_payroll_freq_rules

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;