DBA Data[Home] [Help]

APPS.HR_DELETE dependencies on PAY_CUSTOM_RESTRICTIONS_TL

Line 240: delete records from PAY_CUSTOM_RESTRICTIONS_TL

236: 115.19 09-DEC-02 jonward Deleted grade MLS table
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.

Line 1819: DELETE pay_custom_restrictions_tl crtl

1815: AND cr.business_group_id = p_business_group_id);
1816: hr_utility.set_location(l_proc, 30);
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