DBA Data[Home] [Help]

APPS.HR_PERSON_INTERNAL dependencies on PER_PERIODS_OF_PLACEMENT

Line 807: from per_periods_of_placement ppp

803: and ppt2.system_person_type <> ppt.system_person_type
804: )
805: or exists
806: ( select null
807: from per_periods_of_placement ppp
808: where ppp.person_id=ppf.person_id
809: and actual_termination_date>=p_effective_date
810: and actual_termination_date is not null)); --fix for bug 6730008.
811: --

Line 1695: delete from per_periods_of_placement p

1691: hr_utility.set_location(l_proc, 190);
1692: end if;
1693: --
1694: begin
1695: delete from per_periods_of_placement p
1696: where p.person_id = P_PERSON_ID;
1697: exception
1698: when NO_DATA_FOUND then null;
1699: end;

Line 3712: delete from per_periods_of_placement p

3708: end if;
3709: --
3710: --
3711: begin
3712: delete from per_periods_of_placement p
3713: where p.person_id = P_PERSON_ID;
3714: exception
3715: when NO_DATA_FOUND then
3716: if g_debug then