Line 450: fnd_profile.value('PER_USE_TITLE_IN_FULL_NAME') = 'Y' then
446: */
447:
448: -- bug fix for 2581959
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'