DBA Data[Home] [Help]

APPS.PAY_ELEMENT_TYPES_PKG dependencies on PAY_ELEMENT_SPAN_USAGES

Line 1046: -- Bug 14189892 Need to delete entries in pay_element_span_usages

1042: pay_retro_comp_usage_internal.delete_child_retro_comp_usages
1043: (p_effective_date => p_session_date
1044: ,p_element_type_id => p_element_type_id
1045: );
1046: -- Bug 14189892 Need to delete entries in pay_element_span_usages
1047: -- when date mode is ZAP
1048: delete from pay_element_span_usages
1049: where RETRO_ELEMENT_TYPE_ID = p_element_type_id;
1050: hr_utility.trace('Deleted entry in PAY_ELEMENT_SPAN_USAGES with RETRO_ELEMENT_TYPE_ID ' || p_element_type_id );

Line 1048: delete from pay_element_span_usages

1044: ,p_element_type_id => p_element_type_id
1045: );
1046: -- Bug 14189892 Need to delete entries in pay_element_span_usages
1047: -- when date mode is ZAP
1048: delete from pay_element_span_usages
1049: where RETRO_ELEMENT_TYPE_ID = p_element_type_id;
1050: hr_utility.trace('Deleted entry in PAY_ELEMENT_SPAN_USAGES with RETRO_ELEMENT_TYPE_ID ' || p_element_type_id );
1051:
1052: elsif p_delete_mode = 'DELETE' then

Line 1050: hr_utility.trace('Deleted entry in PAY_ELEMENT_SPAN_USAGES with RETRO_ELEMENT_TYPE_ID ' || p_element_type_id );

1046: -- Bug 14189892 Need to delete entries in pay_element_span_usages
1047: -- when date mode is ZAP
1048: delete from pay_element_span_usages
1049: where RETRO_ELEMENT_TYPE_ID = p_element_type_id;
1050: hr_utility.trace('Deleted entry in PAY_ELEMENT_SPAN_USAGES with RETRO_ELEMENT_TYPE_ID ' || p_element_type_id );
1051:
1052: elsif p_delete_mode = 'DELETE' then
1053: --
1054: -- We need to remove any payroll frequency rules starting after the new end