DBA Data[Home] [Help]

APPS.HR_DELETE dependencies on PAY_MONETARY_UNITS_TL

Line 243: pay_monetary_units_tl in

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.

Line 539: DELETE FROM pay_monetary_units_tl montl

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