686: --
687: function get_label(p_lookup_type in varchar2,
688: p_lookup_code in varchar2) return varchar2 is
689:
690: l_meaning hr_lookups.meaning%TYPE;
691:
692: CURSOR cur_get_meaning IS
693: SELECT hl.meaning
694: FROM hr_lookups hl
690: l_meaning hr_lookups.meaning%TYPE;
691:
692: CURSOR cur_get_meaning IS
693: SELECT hl.meaning
694: FROM hr_lookups hl
695: WHERE hl.lookup_type = p_lookup_type AND
696: hl.lookup_code = p_lookup_code;
697:
698: BEGIN