1533: -- function to get labels of items from a lookup
1534: FUNCTION get_lookup_meaning (p_lookup_type varchar2,p_lookup_code varchar2) RETURN VARCHAR2 IS
1535: CURSOR csr_lookup IS
1536: select meaning
1537: from hr_lookups
1538: where lookup_type = p_lookup_type
1539: and lookup_code = p_lookup_code;
1540: l_meaning hr_lookups.meaning%type;
1541: BEGIN
1536: select meaning
1537: from hr_lookups
1538: where lookup_type = p_lookup_type
1539: and lookup_code = p_lookup_code;
1540: l_meaning hr_lookups.meaning%type;
1541: BEGIN
1542: OPEN csr_lookup;
1543: FETCH csr_lookup INTO l_Meaning;
1544: CLOSE csr_lookup;