20: FUNCTION C_LP_STATUS_p RETURN varchar2 IS
21:
22: CURSOR c_lookup_code IS
23: select es.meaning 24: from hr_lookups es 25: WHERE es.lookup_type = 'OTA_LP_CURRENT_STATUS'
26: AND sysdate BETWEEN NVL(es.start_date_active,sysdate) AND NVL (es.end_date_active, sysdate)
27: AND es.enabled_flag ='Y'
28: AND es.lookup_code = P_LP_STATUS_CODE ;