953:
954: end;
955:
956: FUNCTION get_lookup_meaning(
957: p_lookup_type hr_lookups.lookup_type%TYPE
958: ,p_lookup_code hr_lookups.lookup_code%TYPE)
959: RETURN VARCHAR2 IS
960:
961: l_ret_val hr_lookups.meaning%TYPE := NULL;
954: end;
955:
956: FUNCTION get_lookup_meaning(
957: p_lookup_type hr_lookups.lookup_type%TYPE
958: ,p_lookup_code hr_lookups.lookup_code%TYPE)
959: RETURN VARCHAR2 IS
960:
961: l_ret_val hr_lookups.meaning%TYPE := NULL;
962:
957: p_lookup_type hr_lookups.lookup_type%TYPE
958: ,p_lookup_code hr_lookups.lookup_code%TYPE)
959: RETURN VARCHAR2 IS
960:
961: l_ret_val hr_lookups.meaning%TYPE := NULL;
962:
963: CURSOR cur_loc IS
964: SELECT loc.meaning
965: FROM hr_lookups loc
961: l_ret_val hr_lookups.meaning%TYPE := NULL;
962:
963: CURSOR cur_loc IS
964: SELECT loc.meaning
965: FROM hr_lookups loc
966: WHERE
967: loc.lookup_type = p_lookup_type
968: AND loc.lookup_code = p_lookup_code;
969: