1246: (p_lookup_code in varchar2,
1247: p_lookup_type in varchar2) return varchar2 is
1248:
1249: cursor csr_meaning is select meaning
1250: from hr_lookups hrl
1251: where p_lookup_code = hrl.lookup_code
1252: and p_lookup_type = hrl.lookup_type
1253: and hrl.application_id = 800;
1254:
1253: and hrl.application_id = 800;
1254:
1255: -- set up the variables
1256:
1257: l_meaning hr_lookups.meaning%type;
1258:
1259: begin
1260:
1261: open csr_meaning;