APPS.HR_DELETE dependencies on PAY_ELEMENT_TYPES_F_TL

Line 234: 115.18 21-NOV-02 N.Bristow Now deleting from pay_element_types_f_tl,

230: pay_balance_sets, pay_balance_set_members.
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

Line 1536: delete from pay_element_types_f_tl

1532: for et_rec in get_element_types loop
1533: --
1534: -- delete element types
1535: --
1536: delete from pay_element_types_f_tl
1537: where element_type_id = et_rec.element_type_id;
1538: --
1539: delete from pay_element_types_f
1540: where current of get_element_types;