APPS.HR_PERSON_DELETE dependencies on PER_MEDICAL_ASSESSMENTS

Line 146: From PER_MEDICAL_ASSESSMENTS.

142: bug 1403481.
143: 115.17 31-OCT-2000 GPERRY Fixed WWBUG 1294400.
144: Added in checks for benefits.
145: 115.18 20-DEC-2000 MGettins Changed Delete_A_person to now also delete
146: From PER_MEDICAL_ASSESSMENTS.
147: 115.19 08-Aug-2001 Tmathers Added new weak_predel checks when called
148: from delete person screen.
149: 115.20 24-AUG-2001 ASahay Replaced maintain_ptu with
150: delete_person_type_usage

Line 1434: FROM per_medical_Assessments pma

1430: --
1431: CURSOR medical_assessment_records IS
1432: SELECT medical_assessment_id,
1433: object_version_number
1434: FROM per_medical_Assessments pma
1435: WHERE pma.person_id = p_person_id;
1436: --
1437: cursor WORK_INCIDENTS is
1438: select incident_id, object_version_number