APPS.HR_UTIL_MISC_SS dependencies on PER_PEOPLE_F

Line 11: FROM per_people_f ppf, hr_organization_information oi

7: PROCEDURE initLoginPrsnCtx(p_eff_date IN DATE) IS
8: l_proc constant varchar2(100) := g_package || ' initLoginPrsnCtx';
9: CURSOR c_bg IS
10: SELECT business_group_id, nvl(org_information10,'USD') currency_code
11: FROM per_people_f ppf, hr_organization_information oi
12: WHERE ppf.person_id = fnd_global.employee_id
13: AND ppf.business_group_id = oi.organization_id
14: AND oi.org_information_context = 'Business Group Information'
15: AND g_eff_date between ppf.effective_start_date and ppf.effective_end_date;

Line 1125: from per_people_f ppf, per_assignments_f paf

1121: hr_utility.set_location('Entering: '|| l_proc,5);
1122:
1123: select assignment_id
1124: into assi_id
1125: from per_people_f ppf, per_assignments_f paf
1126: where paf.person_id = ppf.person_id
1127: and trunc(sysdate) between paf.effective_start_date(+) and paf.effective_end_date(+)
1128: and trunc(sysdate) between ppf.effective_start_date(+) and ppf.effective_end_date(+)
1129: and ppf.person_id = p_person_id