APPS.HR_DELETE dependencies on PAY_ELEMENT_TYPES_F

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 1419: (c_business_group_id pay_element_types_f.business_group_id%TYPE)

1415: --
1416: l_exists varchar2(1);
1417: --
1418: cursor csr_get_ele_types
1419: (c_business_group_id pay_element_types_f.business_group_id%TYPE)
1420: is
1421: SELECT null
1422: FROM pay_element_types_f
1423: WHERE business_group_id = c_business_group_id;

Line 1422: FROM pay_element_types_f

1418: cursor csr_get_ele_types
1419: (c_business_group_id pay_element_types_f.business_group_id%TYPE)
1420: is
1421: SELECT null
1422: FROM pay_element_types_f
1423: WHERE business_group_id = c_business_group_id;
1424: --
1425: --
1426: -- Cursor to loop through all input values in order to delete

Line 1434: FROM pay_element_types_f pet

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)
1437: FOR UPDATE;
1438: --

Line 1444: FROM pay_element_types_f

1440: -- database items
1441: --
1442: CURSOR get_element_types is
1443: SELECT element_type_id
1444: FROM pay_element_types_f
1445: WHERE business_group_id = p_business_group_id
1446: FOR UPDATE;
1447: --
1448: -- This cursor deletes link input values

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;

Line 1539: delete from pay_element_types_f

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;
1541: --
1542: --
1543: end loop;