APPS.HR_DELETE dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 177: from hr_assignment_set_amendments,

173: PER_QUAL_SUBJECT_USAGES
174: PER_QUALIFICATION_TYPES
175: PER_QUALIFICATIONS
176: 70.42 30-SEP-96 N.Bristow Constraint error encountered when deleting
177: from hr_assignment_set_amendments,
178: deletions where being performed in the
179: wrong order.
180:
181: 70.43 06-OCT-96 D.Kerr Temporarily removed delete_competence_detail

Line 971: DELETE FROM hr_assignment_set_amendments asa

967: WHERE pa.assignment_id = alu.assignment_id
968: AND pa.business_group_id = p_business_group_id);
969: hr_utility.set_location(l_proc,235);
970: --
971: DELETE FROM hr_assignment_set_amendments asa
972: WHERE EXISTS ( SELECT ''
973: FROM per_assignments_f pa
974: WHERE pa.assignment_id = asa.assignment_id
975: AND pa.business_group_id = p_business_group_id);