DBA Data[Home] [Help]

APPS.HR_PERSON_INTERNAL dependencies on PER_PHONES

Line 1566: delete from per_phones a

1562: hr_utility.set_location(l_proc, 80);
1563: end if;
1564: --
1565: begin
1566: delete from per_phones a
1567: where a.parent_id = P_PERSON_ID
1568: and a.parent_table = 'PER_ALL_PEOPLE_F';
1569: exception
1570: when NO_DATA_FOUND then null;

Line 1830: delete from per_phones a

1826: hr_utility.set_location(l_proc, 50);
1827: end if;
1828: --
1829: begin
1830: delete from per_phones a
1831: where a.parent_id = P_PERSON_ID
1832: and a.parent_table = 'PER_ALL_PEOPLE_F';
1833: exception
1834: when NO_DATA_FOUND then null;

Line 2931: delete from per_phones a

2927: end if;
2928: --
2929: begin
2930: --
2931: delete from per_phones a
2932: where a.parent_id = P_PERSON_ID
2933: and a.parent_table = 'PER_ALL_PEOPLE_F';
2934: --
2935: exception