312: l_location_id2 NUMBER;
313:
314: CURSOR check_location IS
315: SELECT hrtl.location_id
316: FROM hr_locations_all_tl hrtl,
317: hr_locations_all hr
318: WHERE hrtl.location_code = p_location_code
319: AND hrtl.language = USERENV('LANG')
320: AND hrtl.location_id = hr.location_id
313:
314: CURSOR check_location IS
315: SELECT hrtl.location_id
316: FROM hr_locations_all_tl hrtl,
317: hr_locations_all hr
318: WHERE hrtl.location_code = p_location_code
319: AND hrtl.language = USERENV('LANG')
320: AND hrtl.location_id = hr.location_id
321: AND trunc(sysdate) <= nvl( hr.inactive_date, trunc(sysdate) ) ;