2989: p_type in VARCHAR2)
2990: RETURN VARCHAR2 IS
2991: CURSOR CUR_lookup IS
2992: SELECT LOOKUP_CODE,MEANING 2993: FROM HR_LOOKUPS 2994: WHERE LOOKUP_TYPE = p_type
2995: AND ENABLED_FLAG = 'Y'
2996: AND trunc(sysDATE)
2997: BETWEEN NVL(START_DATE_ACTIVE,trunc(sysDATE))