APPS.HR_DELETE dependencies on PAY_INPUT_VALUES_F

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 1432: FROM pay_input_values_f iv

1428: --
1429: CURSOR get_input_values is
1430: SELECT iv.input_value_id input_value_id,
1431: iv.generate_db_items_flag generate_db_items_flag
1432: FROM pay_input_values_f iv
1433: WHERE EXISTS ( SELECT ''
1434: FROM pay_element_types_f pet
1435: WHERE pet.element_type_id = iv.element_type_id
1436: AND pet.business_group_id = p_business_group_id)

Line 1523: DELETE FROM pay_input_values_f

1519: for iv_rec in get_input_values loop
1520: --
1521: -- Delete input values
1522: --
1523: DELETE FROM pay_input_values_f
1524: WHERE CURRENT OF get_input_values;
1525: --
1526: delete from pay_input_values_f_tl
1527: where input_value_id = iv_rec.input_value_id;

Line 1526: delete from pay_input_values_f_tl

1522: --
1523: DELETE FROM pay_input_values_f
1524: WHERE CURRENT OF get_input_values;
1525: --
1526: delete from pay_input_values_f_tl
1527: where input_value_id = iv_rec.input_value_id;
1528: --
1529: end loop;
1530: hr_utility.set_location(l_proc, 100);