DBA Data[Home] [Help]

APPS.HXC_SUPERVISOR_DASHBOARD dependencies on HR_LOCATIONS_ALL_TL

Line 1079: hr_locations_all_tl hxl, hxc_temp_tcd htt

1075: DISTINCT
1076: hxl.location_code,
1077: htt.location_name
1078: FROM
1079: hr_locations_all_tl hxl, hxc_temp_tcd htt
1080: WHERE hxl.location_id = htt.location_name
1081: AND htt.user_id = p_user_id
1082: AND hxl.language = userenv('LANG');
1083:

Line 3171: FROM hr_locations_all_tl

3167: IF p_location IS NOT NULL
3168: THEN
3169: SELECT DISTINCT
3170: location_code INTO l_location_name
3171: FROM hr_locations_all_tl
3172: WHERE location_id = p_location
3173: AND language = userenv('LANG');
3174: END IF;
3175: