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
Line 30: FROM ar_lookups
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