APPS.HR_DELETE dependencies on PAY_BALANCE_TYPES_TL

Line 235: pay_input_values_f_tl and pay_balance_types_tl

231: - Update the secondary_status for any purge
232: assignment actions before attempting to
233: call rollback_payroll_action procedure.
234: 115.18 21-NOV-02 N.Bristow Now deleting from pay_element_types_f_tl,
235: pay_input_values_f_tl and pay_balance_types_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

Line 1770: DELETE FROM pay_balance_types_tl pbt

1766: DELETE FROM pay_balance_feeds_f pbf
1767: WHERE pbf.balance_type_id = balrec.balance_type_id;
1768: hr_utility.set_location('Leaving: '||l_proc,90);
1769: --
1770: DELETE FROM pay_balance_types_tl pbt
1771: WHERE pbt.balance_type_id = balrec.balance_type_id;
1772: hr_utility.set_location('Leaving: '||l_proc,95);
1773: --
1774: DELETE FROM pay_balance_types pbt