APPS.HR_DELETE dependencies on PAY_CUSTOMIZED_RESTRICTIONS

Line 241: before deleting from PAY_CUSTOMIZED_RESTRICTIONS

237: 115.20 13-DEC-02 pmfletch Added delete from positions MLS table
238: 115.21 27-DEC-02 joward Added delete from jobs MLS table
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.

Line 1812: FROM pay_customized_restrictions cr

1808: hr_utility.set_location(l_proc, 20);
1809: --
1810: DELETE pay_restriction_values rv
1811: WHERE EXISTS (SELECT ''
1812: FROM pay_customized_restrictions cr
1813: WHERE cr.customized_restriction_id
1814: = rv.customized_restriction_id
1815: AND cr.business_group_id = p_business_group_id);
1816: hr_utility.set_location(l_proc, 30);

Line 1821: FROM pay_customized_restrictions cr

1817: --
1818:
1819: DELETE pay_custom_restrictions_tl crtl
1820: WHERE EXISTS (SELECT ''
1821: FROM pay_customized_restrictions cr
1822: WHERE cr.customized_restriction_id
1823: = crtl.customized_restriction_id
1824: AND cr.business_group_id = p_business_group_id);
1825: hr_utility.set_location(l_proc, 35);

Line 1829: DELETE pay_customized_restrictions cr

1825: hr_utility.set_location(l_proc, 35);
1826:
1827: ------
1828:
1829: DELETE pay_customized_restrictions cr
1830: WHERE cr.business_group_id = p_business_group_id;
1831: hr_utility.set_location(l_proc, 40);
1832: --
1833: DELETE pay_user_column_instances_f uci