32:
33: FUNCTION C_ANSWER_TYPE_p RETURN varchar2 IS
34: cursor c_lookup_code is
35: select es.meaning 36: from hr_lookups es 37: WHERE es.lookup_type='OTA_EVAL_REPORT_TYPE'
38: AND sysdate BETWEEN NVL(es.start_date_active,sysdate) AND NVL (es.end_date_active, sysdate)
39: AND es.enabled_flag ='Y'
40: AND es.lookup_code = P_ANSWER_TYPE ;