eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 1495: AND entity_name IN('PER_ALL_PEOPLE_F','PER_PEOPLE_F'); -- added for bug 9411745

1491: CURSOR attached_docs_cursor1 IS
1492: SELECT attached_document_id
1493: FROM fnd_attached_documents
1494: WHERE pk1_value = l_pk1_value1
1495: AND entity_name IN('PER_ALL_PEOPLE_F','PER_PEOPLE_F'); -- added for bug 9411745
1496: --
1497: cursor delattachments_cursor1 (x_attached_document_id in number) is
1498: select datatype_id
1499: from fnd_attached_docs_form_vl

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

1594: --
1595: begin
1596: delete from per_phones a
1597: where a.parent_id = P_PERSON_ID
1598: and a.parent_table = 'PER_ALL_PEOPLE_F';
1599: exception
1600: when NO_DATA_FOUND then null;
1601: end;
1602: --

Line 1792: AND entity_name IN('PER_ALL_PEOPLE_F','PER_PEOPLE_F'); -- added for bug 9411745

1788: CURSOR attached_docs_cursor2 IS
1789: SELECT attached_document_id
1790: FROM fnd_attached_documents
1791: WHERE pk1_value = l_pk1_value2
1792: AND entity_name IN('PER_ALL_PEOPLE_F','PER_PEOPLE_F'); -- added for bug 9411745
1793: --
1794: cursor delattachments_cursor2 (x_attached_document_id in number) is
1795: select datatype_id
1796: from fnd_attached_docs_form_vl

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

1859: --
1860: begin
1861: delete from per_phones a
1862: where a.parent_id = P_PERSON_ID
1863: and a.parent_table = 'PER_ALL_PEOPLE_F';
1864: exception
1865: when NO_DATA_FOUND then null;
1866: end;
1867: --

Line 2039: AND entity_name IN('PER_ALL_PEOPLE_F','PER_PEOPLE_F'); -- added for bug 9411745

2035: CURSOR attached_docs_cursor IS
2036: SELECT attached_document_id
2037: FROM fnd_attached_documents
2038: WHERE pk1_value = l_pk1_value3
2039: AND entity_name IN('PER_ALL_PEOPLE_F','PER_PEOPLE_F'); -- added for bug 9411745
2040: --
2041: cursor delattachments_cursor (x_attached_document_id in number) is
2042: select datatype_id
2043: from fnd_attached_docs_form_vl

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

2982: begin
2983: --
2984: delete from per_phones a
2985: where a.parent_id = P_PERSON_ID
2986: and a.parent_table = 'PER_ALL_PEOPLE_F';
2987: --
2988: exception
2989: when NO_DATA_FOUND then
2990: if g_debug then

Line 3572: from per_all_people_f

3568: begin
3569: -- Fix for 4490489 starts here
3570: --
3571: select distinct party_id into l_party_id
3572: from per_all_people_f
3573: where person_id = p_person_id;
3574: --
3575: select count(distinct person_id) into l_count
3576: from per_all_people_f

Line 3576: from per_all_people_f

3572: from per_all_people_f
3573: where person_id = p_person_id;
3574: --
3575: select count(distinct person_id) into l_count
3576: from per_all_people_f
3577: where party_id = l_party_id;
3578: --
3579: if l_count = 1 then
3580: --PMFLETCH Added delete from tl table

Line 3686: delete from per_all_people_f

3682: --changes for 5166353 ends here
3683: --
3684: begin
3685: --
3686: delete from per_all_people_f
3687: where person_id = P_PERSON_ID;
3688: exception
3689: when NO_DATA_FOUND then
3690: if g_debug then