784: --
785: -------------------------------------------------------------------
786: CURSOR cur_get_meaning IS
787: SELECT meaning
788: FROM igs_lookup_values
789: WHERE lookup_code = p_lookup_code
790: AND lookup_type = p_lookup_type;
791: l_c_meaning igs_lookup_values.meaning%TYPE;
792:
787: SELECT meaning
788: FROM igs_lookup_values
789: WHERE lookup_code = p_lookup_code
790: AND lookup_type = p_lookup_type;
791: l_c_meaning igs_lookup_values.meaning%TYPE;
792:
793: BEGIN
794: OPEN cur_get_meaning;
795: FETCH cur_get_meaning INTO l_c_meaning;