4: FUNCTION get_lookup_value (p_lookup_code VARCHAR2) RETURN VARCHAR2 IS
5:
6: CURSOR c_get_lookup_value IS
7: SELECT meaning 8: FROM fnd_lookups 9: WHERE lookup_type = 'PO_EDA_COMPLETION_STATUS'
10: AND (SYSDATE BETWEEN start_date_active AND Nvl(end_date_active,SYSDATE+1))
11: AND lookup_code = p_lookup_code ;
12: