DBA Data[Home] [Help]

APPS.HR_PERSON dependencies on HR_LOOKUPS

Line 979: FROM hr_lookups

975: if p_title IS NOT NULL and
976: fnd_profile.value('PER_USE_TITLE_IN_FULL_NAME') = 'Y' then
977: SELECT meaning
978: INTO l_title_meaning
979: FROM hr_lookups
980: WHERE lookup_type = 'TITLE'
981: AND p_title = lookup_code;
982: end if;
983: