APPS.HR_DELETE dependencies on PAY_BALANCE_TYPES

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 1714: from pay_balance_types

1710: cursor csr_get_bal_types
1711: (c_business_group_id pay_payrolls_f.business_group_id%TYPE)
1712: is
1713: select balance_type_id
1714: from pay_balance_types
1715: where business_group_id = c_business_group_id;
1716: begin
1717: --
1718: hr_utility.set_location('Entering: '||l_proc,10);

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

Line 1774: DELETE FROM pay_balance_types pbt

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
1775: WHERE pbt.balance_type_id = balrec.balance_type_id;
1776: hr_utility.set_location('Leaving: '||l_proc,100);
1777: --
1778: end loop;