DBA Data[Home] [Help]

APPS.BEN_ELIGIBILITY_OVERRIDE dependencies on HR_LOOKUPS

Line 35: l_meaning hr_lookups.meaning%type;

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

Line 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