1269: (p_lookup_code in varchar2,
1270: p_lookup_type in varchar2) return varchar2 is
1271:
1272: cursor csr_meaning is select meaning
1273: from hr_lookups hrl
1274: where p_lookup_code = hrl.lookup_code
1275: and p_lookup_type = hrl.lookup_type
1276: and hrl.application_id = 800;
1277:
1276: and hrl.application_id = 800;
1277:
1278: -- set up the variables
1279:
1280: l_meaning hr_lookups.meaning%type;
1281:
1282: begin
1283:
1284: open csr_meaning;