APPS.HR_DELETE dependencies on PAY_ELEMENT_LINKS_F

Line 571: pay_element_links_f pel

567: -- This cursor used in the delete of entry values.
568: CURSOR cev is
569: SELECT pee.element_entry_id
570: from pay_element_entries_f pee,
571: pay_element_links_f pel
572: where pel.business_group_id = p_business_group_id
573: and pee.element_link_id = pel.element_link_id;
574: --
575: begin

Line 1452: pay_element_links_f pel

1448: -- This cursor deletes link input values
1449: CURSOR lev is
1450: SELECT liv.link_input_value_id
1451: from pay_link_input_values_f liv,
1452: pay_element_links_f pel
1453: where pel.business_group_id = p_business_group_id
1454: and liv.element_link_id = pel.element_link_id;
1455: --
1456: begin

Line 1468: DELETE FROM pay_element_links_f el

1464: where liv.link_input_value_id = levrec.link_input_value_id;
1465: END LOOP;
1466: hr_utility.set_location(l_proc, 30);
1467: --
1468: DELETE FROM pay_element_links_f el
1469: WHERE el.business_group_id = p_business_group_id;
1470: hr_utility.set_location(l_proc, 40);
1471: --
1472: DELETE FROM pay_element_type_rules etr