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 3570: l_fegli_meaning hr_lookups.meaning%type;

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

Line 3571: l_retirement_plan_meaning hr_lookups.meaning%type;

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

Line 3725: l_fegli_meaning hr_lookups.meaning%type;

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

Line 3726: l_retirement_plan_meaning hr_lookups.meaning%type;

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