861:
862: function get_label(p_lookup_type in varchar2,
863: p_lookup_code in varchar2) return varchar2 is
864:
865: l_meaning hr_lookups.meaning%TYPE;
866:
867: CURSOR cur_get_meaning IS
868: SELECT hl.meaning
869: FROM hr_lookups hl
865: l_meaning hr_lookups.meaning%TYPE;
866:
867: CURSOR cur_get_meaning IS
868: SELECT hl.meaning
869: FROM hr_lookups hl
870: WHERE hl.lookup_type = p_lookup_type AND
871: hl.lookup_code = p_lookup_code;
872:
873: BEGIN