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 2527: -- delete per_people_extra_info records

2523: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 4201);
2524: end;
2525: --
2526: -- 03/18/98 Bug #642566
2527: -- delete per_people_extra_info records
2528: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 46);
2529: --
2530: begin
2531: delete from per_people_extra_info e

Line 2531: delete from per_people_extra_info e

2527: -- delete per_people_extra_info records
2528: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 46);
2529: --
2530: begin
2531: delete from per_people_extra_info e
2532: where e.person_id = P_PERSON_ID;
2533: exception
2534: when NO_DATA_FOUND then
2535: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 4301);