1598: ---------------------------------------------------------------------
1599: -- FUNCTION
1600: -- get_qp_lookup_meaning
1601: -- DESCRIPTION
1602: -- Get the meaning of the given lookup code in qp_lookups.
1603: ---------------------------------------------------------------------
1604: FUNCTION get_qp_lookup_meaning(
1605: p_lookup_type IN VARCHAR2,
1606: p_lookup_code IN VARCHAR2
1610: l_meaning VARCHAR2(80);
1611:
1612: CURSOR c_meaning IS
1613: SELECT meaning
1614: FROM qp_lookups
1615: WHERE lookup_type = UPPER(p_lookup_type)
1616: AND lookup_code = UPPER(p_lookup_code);
1617: BEGIN
1618: IF p_lookup_type IS NULL OR p_lookup_code IS NULL THEN