APPS.HR_NL_UTILITY dependencies on HR_GENERAL

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

145: END IF;
146: CLOSE cur_contact_person_details;
147:
148: --
149: l_title:=hr_general.decode_lookup('TITLE', p_title);
150: l_acad_title:=hr_general.decode_lookup('HR_NL_ACADEMIC_TITLE',
151: p_per_information10);
152: l_sub_acad_title:=hr_general.decode_lookup('HR_NL_SUB_ACADEMIC_TITLE',
153: p_per_information3);

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

146: CLOSE cur_contact_person_details;
147:
148: --
149: l_title:=hr_general.decode_lookup('TITLE', p_title);
150: l_acad_title:=hr_general.decode_lookup('HR_NL_ACADEMIC_TITLE',
151: p_per_information10);
152: l_sub_acad_title:=hr_general.decode_lookup('HR_NL_SUB_ACADEMIC_TITLE',
153: p_per_information3);
154: if p_per_information4 is null then

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

148: --
149: l_title:=hr_general.decode_lookup('TITLE', p_title);
150: l_acad_title:=hr_general.decode_lookup('HR_NL_ACADEMIC_TITLE',
151: p_per_information10);
152: l_sub_acad_title:=hr_general.decode_lookup('HR_NL_SUB_ACADEMIC_TITLE',
153: p_per_information3);
154: if p_per_information4 is null then
155: select p_last_name || ' '
156: || decode (p_pre_name_adjunct,'','',p_pre_name_adjunct || ' ')