DBA Data[Home] [Help]

APPS.HR_UTIL_MISC_SS dependencies on HR_ORGANIZATION_INFORMATION

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;