13: FUNCTION GET_LOOKUP_MEANING (p_lookup_type varchar2,p_lookup_code varchar2) RETURN VARCHAR2 IS
14:
15: CURSOR csr_lookup IS
16: SELECT meaning
17: FROM hr_lookups
18: WHERE lookup_type = p_lookup_type
19: AND lookup_code = p_lookup_code
20: AND enabled_flag = 'Y';
21:
18: WHERE lookup_type = p_lookup_type
19: AND lookup_code = p_lookup_code
20: AND enabled_flag = 'Y';
21:
22: l_meaning hr_lookups.meaning%type;
23:
24: BEGIN
25: OPEN csr_lookup;
26: FETCH csr_lookup INTO l_Meaning;