APPS.HR_PERSON_INTERNAL dependencies on PER_PERIODS_OF_SERVICE

Line 999: from per_periods_of_service p

995: into l_delete_permitted
996: from sys.dual
997: where not exists (
998: select null
999: from per_periods_of_service p
1000: where p.termination_accepted_person_id = P_PERSON_ID);
1001: --
1002: exception
1003: when NO_DATA_FOUND then

Line 1670: delete from per_periods_of_service p

1666: hr_utility.set_location(l_proc, 140);
1667: end if;
1668: --
1669: begin
1670: delete from per_periods_of_service p
1671: where p.person_id = P_PERSON_ID;
1672: exception
1673: when NO_DATA_FOUND then null;
1674: end;

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

2216: if g_debug then
2217: hr_utility.set_location(l_proc, 150);
2218: end if;
2219: --
2220: -- Delete of per_periods_of_service at end after delete of
2221: -- per_assignments_f.
2222: --
2223: begin
2224: --

Line 2225: update per_periods_of_service p

2221: -- per_assignments_f.
2222: --
2223: begin
2224: --
2225: update per_periods_of_service p
2226: set p.termination_accepted_person_id = null
2227: where p.termination_accepted_person_id = P_PERSON_ID;
2228: --
2229: exception

Line 3435: delete from per_periods_of_service p

3431: end if;
3432: --
3433: begin
3434: --
3435: delete from per_periods_of_service p
3436: where p.person_id = P_PERSON_ID;
3437: --
3438: exception
3439: when NO_DATA_FOUND then