3: FUNCTION user_name(
4: p_lookup_type IN VARCHAR2,
5: p_lookup_code IN VARCHAR2) RETURN VARCHAR2
6: IS
7: l_user_name HR_LOOKUPS.MEANING%TYPE;
8: CURSOR csr_user_name IS
9: select meaning
10: from hr_lookups
11: where lookup_type=p_lookup_type
6: IS
7: l_user_name HR_LOOKUPS.MEANING%TYPE;
8: CURSOR csr_user_name IS
9: select meaning
10: from hr_lookups
11: where lookup_type=p_lookup_type
12: and lookup_code=p_lookup_code;
13: BEGIN
14: open csr_user_name;