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 1329: from per_people_f ppf, per_assignments_f paf

1325: hr_utility.set_location('Entering: '|| l_proc,5);
1326:
1327: select assignment_id
1328: into assi_id
1329: from per_people_f ppf, per_assignments_f paf
1330: where paf.person_id = ppf.person_id
1331: and trunc(sysdate) between paf.effective_start_date(+) and paf.effective_end_date(+)
1332: and trunc(sysdate) between ppf.effective_start_date(+) and ppf.effective_end_date(+)
1333: and ppf.person_id = p_person_id

Line 1968: l_entity_name := 'PER_PEOPLE_F';

1964: --Code Fix for Bug 14085358
1965: l_api_name = 'HR_PROCESS_CONTACT_SS.PROCESS_API') then
1966: --End of Code Fix for Bug 14085358
1967:
1968: l_entity_name := 'PER_PEOPLE_F';
1969: l_pk_value := trans_row.selected_person_id;
1970:
1971:
1972: if( l_pk_value is null) then