898:
899: end;
900:
901: FUNCTION get_lookup_meaning(
902: p_lookup_type hr_lookups.lookup_type%TYPE
903: ,p_lookup_code hr_lookups.lookup_code%TYPE)
904: RETURN VARCHAR2 IS
905:
906: l_ret_val hr_lookups.meaning%TYPE := NULL;
899: end;
900:
901: FUNCTION get_lookup_meaning(
902: p_lookup_type hr_lookups.lookup_type%TYPE
903: ,p_lookup_code hr_lookups.lookup_code%TYPE)
904: RETURN VARCHAR2 IS
905:
906: l_ret_val hr_lookups.meaning%TYPE := NULL;
907:
902: p_lookup_type hr_lookups.lookup_type%TYPE
903: ,p_lookup_code hr_lookups.lookup_code%TYPE)
904: RETURN VARCHAR2 IS
905:
906: l_ret_val hr_lookups.meaning%TYPE := NULL;
907:
908: CURSOR cur_loc IS
909: SELECT loc.meaning
910: FROM hr_lookups loc
906: l_ret_val hr_lookups.meaning%TYPE := NULL;
907:
908: CURSOR cur_loc IS
909: SELECT loc.meaning
910: FROM hr_lookups loc
911: WHERE
912: loc.lookup_type = p_lookup_type
913: AND loc.lookup_code = p_lookup_code;
914: