APPS.HR_DELETE dependencies on PAY_ELEMENT_SETS

Line 1474: FROM pay_element_sets es

1470: hr_utility.set_location(l_proc, 40);
1471: --
1472: DELETE FROM pay_element_type_rules etr
1473: WHERE EXISTS (SELECT ''
1474: FROM pay_element_sets es
1475: WHERE es.element_set_id = etr.element_set_id
1476: AND es.business_group_id = p_business_group_id);
1477: hr_utility.set_location(l_proc, 50);
1478: --

Line 1481: FROM pay_element_sets es

1477: hr_utility.set_location(l_proc, 50);
1478: --
1479: DELETE FROM pay_ele_classification_rules ecr
1480: WHERE EXISTS (SELECT ''
1481: FROM pay_element_sets es
1482: WHERE es.element_set_id = ecr.element_set_id
1483: AND es.business_group_id = p_business_group_id);
1484: hr_utility.set_location(l_proc, 60);
1485: --

Line 1486: DELETE FROM pay_element_sets es

1482: WHERE es.element_set_id = ecr.element_set_id
1483: AND es.business_group_id = p_business_group_id);
1484: hr_utility.set_location(l_proc, 60);
1485: --
1486: DELETE FROM pay_element_sets es
1487: WHERE es.business_group_id = p_business_group_id;
1488: hr_utility.set_location(l_proc, 70);
1489: --
1490: DELETE FROM pay_sub_classification_rules_f scr