717: return hr_util_misc_web.g_lookup_values_tab_type is
718: --
719: cursor get_lookup_code_meaning is
720: select lookup_code, meaning 721: from hr_lookups 722: where lookup_type = p_lookup_type
723: and enabled_flag = 'Y'
724: and nvl(p_effective_date, trunc(sysdate))
725: between nvl(start_date_active,hr_api.g_sot)
[Home] [Help]