APPS.GHR_MTO_INT dependencies on HR_LOOKUPS

Line 767: l_description hr_lookups.description%type := null;

763: p_lookup_code varchar2)
764: return varchar2 is
765:
766: l_proc varchar2(72) := g_package||'get_code_meaning';
767: l_description hr_lookups.description%type := null;
768:
769: begin
770:
771: if p_lookup_code is null then

Line 3571: l_fegli_meaning hr_lookups.meaning%type;

3567: p_element in out nocopy ghr_mt_element_entries_v%rowtype)
3568: is
3569:
3570: l_proc varchar2(72) := g_package||'insert_element_entries';
3571: l_fegli_meaning hr_lookups.meaning%type;
3572: l_retirement_plan_meaning hr_lookups.meaning%type;
3573: l_table_name constant varchar2(30) := 'PER_ELEMENT_ENTRIES';
3574: l_name varchar2(30);
3575:

Line 3572: l_retirement_plan_meaning hr_lookups.meaning%type;

3568: is
3569:
3570: l_proc varchar2(72) := g_package||'insert_element_entries';
3571: l_fegli_meaning hr_lookups.meaning%type;
3572: l_retirement_plan_meaning hr_lookups.meaning%type;
3573: l_table_name constant varchar2(30) := 'PER_ELEMENT_ENTRIES';
3574: l_name varchar2(30);
3575:
3576: begin

Line 3726: l_fegli_meaning hr_lookups.meaning%type;

3722: p_element in out nocopy ghr_mt_element_entries_v%rowtype)
3723: is
3724:
3725: l_proc varchar2(72) := g_package||'update_element_entries';
3726: l_fegli_meaning hr_lookups.meaning%type;
3727: l_retirement_plan_meaning hr_lookups.meaning%type;
3728: l_x varchar2(1);
3729:
3730: cursor cur_elements is

Line 3727: l_retirement_plan_meaning hr_lookups.meaning%type;

3723: is
3724:
3725: l_proc varchar2(72) := g_package||'update_element_entries';
3726: l_fegli_meaning hr_lookups.meaning%type;
3727: l_retirement_plan_meaning hr_lookups.meaning%type;
3728: l_x varchar2(1);
3729:
3730: cursor cur_elements is
3731: select 'x'