APPS.HR_PERSON_DELETE dependencies on PER_PEOPLE_EXTRA_INFO

Line 104: to delete per_people_extra_info records.

100: PER_PEOPLE_F to PER_ALL_PEOPLE_F
101: 110.3 06-Nov-97 mmillmor 593864 Added pa validation to moderate delete
102:
103: 110.4 18-Mar-98 fychu 642566 Added code to delete_a_person procedure
104: to delete per_people_extra_info records.
105: 110.5 25-MAR-1998 mmillmor Added delete from per_performance_reviews for
106: (in dynamic sql because table
107: may not exist for some clients)
108: 110.6 16-APR-1998 SASmith Change to table from

Line 2598: -- delete per_people_extra_info records

2594: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 4201);
2595: end;
2596: --
2597: -- 03/18/98 Bug #642566
2598: -- delete per_people_extra_info records
2599: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 46);
2600: --
2601: begin
2602: delete from per_people_extra_info e

Line 2602: delete from per_people_extra_info e

2598: -- delete per_people_extra_info records
2599: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 46);
2600: --
2601: begin
2602: delete from per_people_extra_info e
2603: where e.person_id = P_PERSON_ID;
2604: exception
2605: when NO_DATA_FOUND then
2606: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 4301);