APPS.PER_PEOPLE12_PKG dependencies on PER_PEOPLE_F

Line 1232: -- update per_people_f ppf

1228: hr_utility.set_location('PER_PEOPLE12_PKG.update_row2 '||hr_person_type_usage_info.get_default_person_type_id(
1229: p_business_group_id,p_system_person_type),272);
1230:
1231: -- Bug 6196362 Starts.
1232: -- update per_people_f ppf
1233: update per_all_people_f ppf
1234: -- Bug 6196362 Ends.
1235: set ppf.person_id = p_person_id
1236: ,ppf.effective_start_date = p_effective_start_date

Line 3699: -- update per_people_f ppf

3695: hr_utility.set_location('PER_PEOPLE12_PKG.update_row1 '||hr_person_type_usage_info.get_default_person_type_id(
3696: p_business_group_id,p_system_person_type),272);
3697:
3698: -- Bug 6196362 Starts.
3699: -- update per_people_f ppf
3700: update per_all_people_f ppf
3701: -- Bug 6196362 Ends.
3702: set ppf.person_id = p_person_id
3703: ,ppf.effective_start_date = p_effective_start_date

Line 4085: from per_people_f ppf

4081: select '1'
4082: from sys.dual
4083: where exists (
4084: select 'future assignment exists'
4085: from per_people_f ppf
4086: where ppf.person_id = p_person_id
4087: and ppf.effective_start_date > p_effective_start_date
4088: );
4089: -- ER FPT

Line 4193: FROM per_people_f per

4189: -- Cursor to get legislation code
4190: --
4191: CURSOR csr_per_legislation IS
4192: SELECT bus.legislation_code
4193: FROM per_people_f per
4194: ,per_business_groups bus
4195: WHERE per.person_id = p_person_id
4196: AND per.business_group_id+0 = bus.business_group_id
4197: AND p_start_date BETWEEN per.effective_start_date