374: ,p_lookup_code varchar2)
375: RETURN VARCHAR2 IS
376: CURSOR csr_lookup IS
377: select meaning
378: from hr_lookups
379: where lookup_type = p_lookup_type
380: and lookup_code = p_lookup_code;
381: l_meaning hr_lookups.meaning%type;
382: BEGIN
377: select meaning
378: from hr_lookups
379: where lookup_type = p_lookup_type
380: and lookup_code = p_lookup_code;
381: l_meaning hr_lookups.meaning%type;
382: BEGIN
383: OPEN csr_lookup;
384: FETCH csr_lookup INTO l_Meaning;
385: CLOSE csr_lookup;