APPS.PER_PEOPLE12_PKG dependencies on PER_PEOPLE_F

Line 1417: -- update per_people_f ppf

1413: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 '||hr_person_type_usage_info.get_default_person_type_id(
1414: p_business_group_id,p_system_person_type),272);
1415:
1416: -- Bug 6196362 Starts.
1417: -- update per_people_f ppf
1418: update per_all_people_f ppf
1419: -- Bug 6196362 Ends.
1420: set ppf.person_id = p_person_id
1421: ,ppf.effective_start_date = p_effective_start_date

Line 1783: from per_people_f ppf

1779: select '1'
1780: from sys.dual
1781: where exists (
1782: select 'future assignment exists'
1783: from per_people_f ppf
1784: where ppf.person_id = p_person_id
1785: and ppf.effective_start_date > p_effective_start_date
1786: );
1787: begin

Line 1870: FROM per_people_f per

1866: -- Cursor to get legislation code
1867: --
1868: CURSOR csr_per_legislation IS
1869: SELECT bus.legislation_code
1870: FROM per_people_f per
1871: ,per_business_groups bus
1872: WHERE per.person_id = p_person_id
1873: AND per.business_group_id+0 = bus.business_group_id
1874: AND p_start_date BETWEEN per.effective_start_date