APPS.HR_PERSON_INTERNAL dependencies on PER_PERIODS_OF_SERVICE

Line 970: from per_periods_of_service p

966: into l_delete_permitted
967: from sys.dual
968: where not exists (
969: select null
970: from per_periods_of_service p
971: where p.termination_accepted_person_id = P_PERSON_ID);
972: --
973: exception
974: when NO_DATA_FOUND then

Line 1640: delete from per_periods_of_service p

1636: hr_utility.set_location(l_proc, 140);
1637: end if;
1638: --
1639: begin
1640: delete from per_periods_of_service p
1641: where p.person_id = P_PERSON_ID;
1642: exception
1643: when NO_DATA_FOUND then null;
1644: end;

Line 2188: -- Delete of per_periods_of_service at end after delete of

2184: if g_debug then
2185: hr_utility.set_location(l_proc, 150);
2186: end if;
2187: --
2188: -- Delete of per_periods_of_service at end after delete of
2189: -- per_assignments_f.
2190: --
2191: begin
2192: --

Line 2193: update per_periods_of_service p

2189: -- per_assignments_f.
2190: --
2191: begin
2192: --
2193: update per_periods_of_service p
2194: set p.termination_accepted_person_id = null
2195: where p.termination_accepted_person_id = P_PERSON_ID;
2196: --
2197: exception

Line 3382: delete from per_periods_of_service p

3378: end if;
3379: --
3380: begin
3381: --
3382: delete from per_periods_of_service p
3383: where p.person_id = P_PERSON_ID;
3384: --
3385: exception
3386: when NO_DATA_FOUND then