DBA Data[Home] [Help]

APPS.HR_US_UTILITY dependencies on FND_PROFILE

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'