APPS.HR_GB_UTILITY dependencies on HR_LOOKUPS

Line 65: from hr_lookups hlu

61: c_lookup_code in varchar2,
62: c_effective_date in date) is
63: select 1 from dual where exists
64: (select hlu.lookup_code
65: from hr_lookups hlu
66: where hlu.lookup_type = c_lookup_type
67: and hlu.lookup_code = c_lookup_code
68: and c_effective_date between
69: nvl(hlu.start_date_active, p_effective_date)

Line 458: l_title hr_lookups.meaning%TYPE;

454: RETURN VARCHAR2 IS
455: --
456: l_full_name per_all_people_f.full_name%TYPE;
457: --
458: l_title hr_lookups.meaning%TYPE;
459: l_part2 varchar2(240);
460: BEGIN
461: --
462: -- bug fix for 2504672

Line 473: FROM hr_lookups

469: if p_title IS NOT NULL and
470: fnd_profile.value('PER_USE_TITLE_IN_FULL_NAME') = 'Y' then
471: SELECT meaning
472: INTO l_title
473: FROM hr_lookups
474: WHERE lookup_type = 'TITLE'
475: AND p_title = lookup_code
476: AND application_id = 800;
477: end if;