APPS.HR_PERSON_INTERNAL dependencies on PER_PEOPLE_F

Line 413: from per_people_f p

409: into l_other_only
410: from sys.dual
411: where not exists
412: (select null
413: from per_people_f p
414: where p.person_id = P_CONTACT_PERSON_ID
415: and p.current_emp_or_apl_flag = 'Y');
416: --
417: exception

Line 798: -- rather than per_people_f

794: --
795: -- Fix for bug 7045968 starts here
796: -- Modified the select statement to use the person_type_id from
797: -- per_person_type_usages_f
798: -- rather than per_people_f
799:
800: /*select count(*)
801: into l_person_types
802: from per_people_f ppf,

Line 802: from per_people_f ppf,

798: -- rather than per_people_f
799:
800: /*select count(*)
801: into l_person_types
802: from per_people_f ppf,
803: per_person_types ppt
804: where ppf.person_id = P_PERSON_ID
805: and ppf.effective_end_date >= p_effective_date
806: and ppf.person_type_id = ppt.person_type_id

Line 809: from per_people_f ppf2,

805: and ppf.effective_end_date >= p_effective_date
806: and ppf.person_type_id = ppt.person_type_id
807: and ( exists
808: (select null
809: from per_people_f ppf2,
810: per_person_types ppt2
811: where ppf2.person_id = ppf.person_id
812: and ppf2.effective_end_date >= p_effective_date
813: and ppf2.person_type_id = ppt2.person_type_id

Line 1487: from per_people_f

1483:
1484: --
1485: CURSOR lock_person_rows IS
1486: select person_id
1487: from per_people_f
1488: where person_id = P_PERSON_ID
1489: FOR UPDATE;
1490: --
1491: CURSOR attached_docs_cursor1 IS

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 1714: delete from per_people_f

1710: hr_utility.set_location(l_proc, 180);
1711: end if;
1712: --
1713: begin
1714: delete from per_people_f
1715: where person_id = P_PERSON_ID;
1716: exception
1717: when NO_DATA_FOUND then null;
1718: end;

Line 1784: FROM per_people_f

1780:
1781: --
1782: CURSOR lock_person_rows IS
1783: SELECT person_id
1784: FROM per_people_f
1785: WHERE person_id = P_PERSON_ID
1786: FOR UPDATE;
1787: --
1788: CURSOR attached_docs_cursor2 IS

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 1929: delete from per_people_f

1925: hr_utility.set_location(l_proc, 110);
1926: end if;
1927: --
1928: begin
1929: delete from per_people_f
1930: where person_id = P_PERSON_ID;
1931: exception
1932: when NO_DATA_FOUND then null;
1933: end;

Line 1984: FROM per_people_f

1980: WHERE person_id = P_PERSON_ID;
1981: --
1982: CURSOR csr_lock_person_rows IS
1983: SELECT person_id
1984: FROM per_people_f
1985: WHERE person_id = P_PERSON_ID
1986: FOR UPDATE;
1987: --
1988: CURSOR csr_lock_assignment_rows IS

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