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