APPS.HR_PSF_SHD dependencies on HR_ALL_POSITIONS_F_TL

Line 142: l_name hr_all_positions_f_tl.name%type;

138: l_dummy varchar2(10);
139: l_start_date date;
140: l_expiration_date date;
141: cnt number;
142: l_name hr_all_positions_f_tl.name%type;
143: --
144: begin
145: --
146: g_debug := hr_utility.debug_enabled;

Line 178: select name into l_name from hr_all_positions_f_tl where position_id = l_position_id and language = userenv('LANG');

174: into l_start_date, l_expiration_date from hr_all_positions_f
175: where position_id = l_position_id and availability_status_id = 1;
176:
177: begin
178: select name into l_name from hr_all_positions_f_tl where position_id = l_position_id and language = userenv('LANG');
179: exception when others then
180: null;
181: end;
182: