APPS.HR_PERSON_INTERNAL dependencies on PER_ALL_PEOPLE_F

Line 67: from per_all_people_f p

63: BEGIN
64: --
65: select count(*)
66: into l_dummy
67: from per_all_people_f p
68: where p.person_id = P_PERSON_ID;
69: --
70: EXCEPTION
71: when NO_DATA_FOUND then

Line 1568: and a.parent_table = 'PER_ALL_PEOPLE_F';

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;
1571: end;
1572: --

Line 1832: and a.parent_table = 'PER_ALL_PEOPLE_F';

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;
1835: end;
1836: --

Line 2933: and a.parent_table = 'PER_ALL_PEOPLE_F';

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
2936: when NO_DATA_FOUND then
2937: if g_debug then

Line 3519: from per_all_people_f

3515: begin
3516: -- Fix for 4490489 starts here
3517: --
3518: select distinct party_id into l_party_id
3519: from per_all_people_f
3520: where person_id = p_person_id;
3521: --
3522: select count(distinct person_id) into l_count
3523: from per_all_people_f

Line 3523: from per_all_people_f

3519: from per_all_people_f
3520: where person_id = p_person_id;
3521: --
3522: select count(distinct person_id) into l_count
3523: from per_all_people_f
3524: where party_id = l_party_id;
3525: --
3526: if l_count = 1 then
3527: --PMFLETCH Added delete from tl table

Line 3633: delete from per_all_people_f

3629: --changes for 5166353 ends here
3630: --
3631: begin
3632: --
3633: delete from per_all_people_f
3634: where person_id = P_PERSON_ID;
3635: exception
3636: when NO_DATA_FOUND then
3637: if g_debug then