APPS.HR_NL_UTILITY dependencies on HR_GENERAL

Line 51: l_title:=hr_general.decode_lookup('TITLE', p_title);

47: l_acad_title varchar2(80);
48: l_sub_acad_title varchar2(80);
49: --
50: BEGIN
51: l_title:=hr_general.decode_lookup('TITLE', p_title);
52: l_acad_title:=hr_general.decode_lookup('HR_NL_ACADEMIC_TITLE',
53: p_per_information10);
54: l_sub_acad_title:=hr_general.decode_lookup('HR_NL_SUB_ACADEMIC_TITLE',
55: p_per_information3);

Line 52: l_acad_title:=hr_general.decode_lookup('HR_NL_ACADEMIC_TITLE',

48: l_sub_acad_title varchar2(80);
49: --
50: BEGIN
51: l_title:=hr_general.decode_lookup('TITLE', p_title);
52: l_acad_title:=hr_general.decode_lookup('HR_NL_ACADEMIC_TITLE',
53: p_per_information10);
54: l_sub_acad_title:=hr_general.decode_lookup('HR_NL_SUB_ACADEMIC_TITLE',
55: p_per_information3);
56: if p_per_information4 is null then

Line 54: l_sub_acad_title:=hr_general.decode_lookup('HR_NL_SUB_ACADEMIC_TITLE',

50: BEGIN
51: l_title:=hr_general.decode_lookup('TITLE', p_title);
52: l_acad_title:=hr_general.decode_lookup('HR_NL_ACADEMIC_TITLE',
53: p_per_information10);
54: l_sub_acad_title:=hr_general.decode_lookup('HR_NL_SUB_ACADEMIC_TITLE',
55: p_per_information3);
56: if p_per_information4 is null then
57: select p_last_name || ' '
58: || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')