1855: ,p_lookup_code varchar2)
1856: RETURN VARCHAR2 IS
1857: CURSOR csr_lookup IS
1858: select meaning
1859: from hr_lookups
1860: where lookup_type = p_lookup_type
1861: and lookup_code = p_lookup_code;
1862: l_meaning hr_lookups.meaning%type;
1863: BEGIN
1858: select meaning
1859: from hr_lookups
1860: where lookup_type = p_lookup_type
1861: and lookup_code = p_lookup_code;
1862: l_meaning hr_lookups.meaning%type;
1863: BEGIN
1864: OPEN csr_lookup;
1865: FETCH csr_lookup INTO l_Meaning;
1866: CLOSE csr_lookup;