50: -----------------------------------------------------------------------------
51: FUNCTION get_lookup_meaning (p_lookup_type varchar2,p_lookup_code varchar2) RETURN VARCHAR2 IS
52: CURSOR csr_lookup IS
53: select meaning
54: from hr_lookups
55: where lookup_type = p_lookup_type
56: and lookup_code = p_lookup_code
57: and enabled_flag ='Y';
58: l_meaning hr_lookups.meaning%type;
54: from hr_lookups
55: where lookup_type = p_lookup_type
56: and lookup_code = p_lookup_code
57: and enabled_flag ='Y';
58: l_meaning hr_lookups.meaning%type;
59: BEGIN
60: OPEN csr_lookup;
61: FETCH csr_lookup INTO l_Meaning;
62: CLOSE csr_lookup;