21:
22: FUNCTION get_lookup_meaning (p_lookup_type IN VARCHAR2,
23: p_lookup_code IN VARCHAR2)
24: RETURN VARCHAR2 IS
25: l_meaning ar_lookups.meaning%TYPE;
26: BEGIN
27:
28: SELECT meaning
29: INTO l_meaning
26: BEGIN
27:
28: SELECT meaning
29: INTO l_meaning
30: FROM ar_lookups
31: WHERE lookup_type = p_lookup_type
32: AND lookup_code = p_lookup_code ;
33: return(l_meaning);
34: EXCEPTION