2828: p_type in VARCHAR2)
2829: RETURN VARCHAR2 IS
2830: CURSOR CUR_lookup IS
2831: SELECT LOOKUP_CODE,MEANING 2832: FROM HR_LOOKUPS 2833: WHERE LOOKUP_TYPE = p_type
2834: AND ENABLED_FLAG = 'Y'
2835: AND trunc(sysDATE)
2836: BETWEEN NVL(START_DATE_ACTIVE,trunc(sysDATE))