DBA Data[Home] [Help]

APPS.HR_PERSON dependencies on HR_LOOKUPS

Line 928: FROM hr_lookups

924: if p_title IS NOT NULL and
925: fnd_profile.value('PER_USE_TITLE_IN_FULL_NAME') = 'Y' then
926: SELECT meaning
927: INTO l_title_meaning
928: FROM hr_lookups
929: WHERE lookup_type = 'TITLE'
930: AND p_title = lookup_code;
931: end if;
932: