Line 104: fnd_profile.value('PER_USE_TITLE_IN_FULL_NAME') = 'Y' then
100: BEGIN
101: /* 9506000 */
102: --
103: IF p_title IS NOT NULL and 104: fnd_profile.value('PER_USE_TITLE_IN_FULL_NAME') = 'Y' then 105: SELECT meaning
106: INTO l_title_meaning
107: FROM hr_lookups
108: WHERE lookup_type = 'TITLE'