APPS.HR_PERSON_DELETE dependencies on PER_ADDRESSES

Line 2234: delete from per_addresses a

2230: --
2231: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 25);
2232: --
2233: begin
2234: delete from per_addresses a
2235: where a.person_id = P_PERSON_ID;
2236: exception
2237: when NO_DATA_FOUND then
2238: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 2501);

Line 2896: delete from per_addresses a

2892: --
2893: hr_utility.set_location('HR_PERSON_DELETE.PEOPLE_DEFAULT_DELETES', 7);
2894: --
2895: begin
2896: delete from per_addresses a
2897: where a.person_id = P_PERSON_ID;
2898: exception
2899: when NO_DATA_FOUND then null;
2900: end;

Line 3085: delete from per_addresses a

3081: --
3082: hr_utility.set_location('HR_PERSON_DELETE.APPLICANT_DEFAULT_DELETES', 6);
3083: --
3084: begin
3085: delete from per_addresses a
3086: where a.person_id = P_PERSON_ID;
3087: exception
3088: when NO_DATA_FOUND then null;
3089: end;