APPS.HR_DELETE dependencies on HR_ASSIGNMENT_SETS

Line 1660: FROM hr_assignment_sets ase

1656: --
1657: DELETE FROM hr_assignment_set_criteria has
1658: WHERE
1659: EXISTS ( SELECT ''
1660: FROM hr_assignment_sets ase
1661: WHERE ase.assignment_set_id = has.assignment_set_id
1662: AND ase.business_group_id = p_business_group_id);
1663: hr_utility.set_location(l_proc,40);
1664: --

Line 1665: DELETE FROM hr_assignment_sets ase

1661: WHERE ase.assignment_set_id = has.assignment_set_id
1662: AND ase.business_group_id = p_business_group_id);
1663: hr_utility.set_location(l_proc,40);
1664: --
1665: DELETE FROM hr_assignment_sets ase
1666: WHERE ase.business_group_id = p_business_group_id;
1667: hr_utility.set_location(l_proc,50);
1668: --
1669: --