APPS.HR_PERSON_INTERNAL dependencies on PER_PERIODS_OF_PLACEMENT

Line 818: from per_periods_of_placement ppp

814: and ppt2.system_person_type <> ppt.system_person_type
815: )
816: or exists
817: (select null
818: from per_periods_of_placement ppp
819: where ppp.person_id=ppf.person_id
820: and actual_termination_date>=p_effective_date
821: and actual_termination_date is not null)
822: or exists

Line 824: from per_periods_of_placement ppp

820: and actual_termination_date>=p_effective_date
821: and actual_termination_date is not null)
822: or exists
823: (select null
824: from per_periods_of_placement ppp
825: where ppp.person_id=ppf.person_id
826: and ppp.date_start>p_effective_date
827: )
828: ); */ --fix for bug 6730008.

Line 1725: delete from per_periods_of_placement p

1721: hr_utility.set_location(l_proc, 190);
1722: end if;
1723: --
1724: begin
1725: delete from per_periods_of_placement p
1726: where p.person_id = P_PERSON_ID;
1727: exception
1728: when NO_DATA_FOUND then null;
1729: end;

Line 3765: delete from per_periods_of_placement p

3761: end if;
3762: --
3763: --
3764: begin
3765: delete from per_periods_of_placement p
3766: where p.person_id = P_PERSON_ID;
3767: exception
3768: when NO_DATA_FOUND then
3769: if g_debug then