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 438: l_title hr_lookups.meaning%TYPE;

434: RETURN VARCHAR2 IS
435: --
436: l_full_name per_all_people_f.full_name%TYPE;
437: --
438: l_title hr_lookups.meaning%TYPE;
439: l_part2 varchar2(240);
440: BEGIN
441: --
442: -- bug fix for 2504672

Line 453: FROM hr_lookups

449: if p_title IS NOT NULL and
450: fnd_profile.value('PER_USE_TITLE_IN_FULL_NAME') = 'Y' then
451: SELECT meaning
452: INTO l_title
453: FROM hr_lookups
454: WHERE lookup_type = 'TITLE'
455: AND p_title = lookup_code
456: AND application_id = 800;
457: end if;