APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on HR_LOOKUPS

Line 52: from hr_lookups hl

48: ,p_lookup_type in varchar2
49: ) return varchar2 is
50: cursor c_lookup_meaning(c_lookup_code in varchar2,c_lookup_type in varchar2) is
51: select hl.meaning
52: from hr_lookups hl
53: where hl.lookup_code = c_lookup_code
54: and hl.lookup_type = c_lookup_type;
55: l_det_dt_meaning hr_lookups.meaning%type;
56: begin

Line 55: l_det_dt_meaning hr_lookups.meaning%type;

51: select hl.meaning
52: from hr_lookups hl
53: where hl.lookup_code = c_lookup_code
54: and hl.lookup_type = c_lookup_type;
55: l_det_dt_meaning hr_lookups.meaning%type;
56: begin
57: -- Begin: Fetch Lookup Meaning for determination or enrollment date code
58: l_det_dt_meaning := null ;
59: open c_lookup_meaning(p_lookup_code,p_lookup_type);