Line 55: fnd_profile.value('PER_USE_TITLE_IN_FULL_NAME') = 'Y' then
51: BEGIN
52: --
53: --Start of fix for Bug 2470801
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'