Line 470: fnd_profile.value('PER_USE_TITLE_IN_FULL_NAME') = 'Y' then
466: */
467:
468: -- bug fix for 2581959
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'