54: if p_title IS NOT NULL and
55: fnd_profile.value('PER_USE_TITLE_IN_FULL_NAME') = 'Y' then
56: SELECT meaning
57: INTO l_title_meaning 58: FROM hr_lookups 59: WHERE lookup_type = 'TITLE'
60: AND p_title = lookup_code;
61: end if;
62: --End of fix for Bug 2470801