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 791: from per_people_f ppf,

787: -- check if person type changes exist.
788: --
789: select count(*)
790: into l_person_types
791: from per_people_f ppf,
792: per_person_types ppt
793: where ppf.person_id = P_PERSON_ID
794: and ppf.effective_end_date >= p_effective_date
795: and ppf.person_type_id = ppt.person_type_id

Line 798: from per_people_f ppf2,

794: and ppf.effective_end_date >= p_effective_date
795: and ppf.person_type_id = ppt.person_type_id
796: and ( exists
797: (select null
798: from per_people_f ppf2,
799: per_person_types ppt2
800: where ppf2.person_id = ppf.person_id
801: and ppf2.effective_end_date >= p_effective_date
802: and ppf2.person_type_id = ppt2.person_type_id

Line 1458: from per_people_f

1454:
1455: --
1456: CURSOR lock_person_rows IS
1457: select person_id
1458: from per_people_f
1459: where person_id = P_PERSON_ID
1460: FOR UPDATE;
1461: --
1462: CURSOR attached_docs_cursor1 IS

Line 1684: delete from per_people_f

1680: hr_utility.set_location(l_proc, 180);
1681: end if;
1682: --
1683: begin
1684: delete from per_people_f
1685: where person_id = P_PERSON_ID;
1686: exception
1687: when NO_DATA_FOUND then null;
1688: end;

Line 1754: FROM per_people_f

1750:
1751: --
1752: CURSOR lock_person_rows IS
1753: SELECT person_id
1754: FROM per_people_f
1755: WHERE person_id = P_PERSON_ID
1756: FOR UPDATE;
1757: --
1758: CURSOR attached_docs_cursor2 IS

Line 1898: delete from per_people_f

1894: hr_utility.set_location(l_proc, 110);
1895: end if;
1896: --
1897: begin
1898: delete from per_people_f
1899: where person_id = P_PERSON_ID;
1900: exception
1901: when NO_DATA_FOUND then null;
1902: end;

Line 1953: FROM per_people_f

1949: WHERE person_id = P_PERSON_ID;
1950: --
1951: CURSOR csr_lock_person_rows IS
1952: SELECT person_id
1953: FROM per_people_f
1954: WHERE person_id = P_PERSON_ID
1955: FOR UPDATE;
1956: --
1957: CURSOR csr_lock_assignment_rows IS