31: --
32: procedure update_count(p_lvl_name in varchar2) is
33:
34: i int;
35: l_meaning hr_lookups.meaning%type;
36:
37: cursor hr_lookup is
38: select hl.meaning
39: from hr_lookups hl
35: l_meaning hr_lookups.meaning%type;
36:
37: cursor hr_lookup is
38: select hl.meaning
39: from hr_lookups hl
40: where hl.lookup_type = 'BEN_COMP_LVL'
41: and hl.lookup_code = p_lvl_name;
42: begin
43: for i in 1..g_lvl_rec.count