APPS.HR_PSF_SHD dependencies on HR_ALL_POSITIONS_F_TL

Line 150: l_name hr_all_positions_f_tl.name%type;

146: l_dummy varchar2(10);
147: l_start_date date;
148: l_expiration_date date;
149: cnt number;
150: l_name hr_all_positions_f_tl.name%type;
151: --
152: l_action varchar2(30) := p_action;
153: l_eff_start_date date;
154: l_date_chk varchar2(10);

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

199: into l_start_date, l_expiration_date from hr_all_positions_f
200: where position_id = l_position_id and availability_status_id = 1;
201:
202: begin
203: select name into l_name from hr_all_positions_f_tl where position_id = l_position_id and language = userenv('LANG');
204: exception when others then
205: null;
206: end;
207: