eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_MAP_LOCATION_REGION_PKG dependencies on HR_LOCATIONS_ALL

Line 152: FROM HR_LOCATIONS_ALL

148: END IF;
149:
150: EXECUTE IMMEDIATE 'SELECT MIN(LOCATION_ID),MAX(LOCATION_ID)
151: FROM ( SELECT location_id, NTILE(:num_instances) OVER (ORDER BY location_id) worker
152: FROM HR_LOCATIONS_ALL
153: WHERE last_update_date >= nvl(:start_date, last_update_date)
154: AND last_update_date < nvl(:end_date, last_update_date+1)
155: )
156: GROUP BY WORKER'

Line 2455: l_region HR_LOCATIONS_ALL.REGION_2%TYPE;

2451: l_organization_id NUMBER;
2452: map_region BOOLEAN := FALSE;
2453: terr_short_name FND_TERRITORIES_TL.TERRITORY_SHORT_NAME%TYPE;
2454: terr_code FND_TERRITORIES_TL.TERRITORY_CODE%TYPE;
2455: l_region HR_LOCATIONS_ALL.REGION_2%TYPE;
2456: l_city HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE;
2457: l_postal_code HR_LOCATIONS_ALL.POSTAL_CODE%TYPE;
2458: l_location_source VARCHAR2(4);
2459: l_inactive_date DATE;

Line 2456: l_city HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE;

2452: map_region BOOLEAN := FALSE;
2453: terr_short_name FND_TERRITORIES_TL.TERRITORY_SHORT_NAME%TYPE;
2454: terr_code FND_TERRITORIES_TL.TERRITORY_CODE%TYPE;
2455: l_region HR_LOCATIONS_ALL.REGION_2%TYPE;
2456: l_city HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE;
2457: l_postal_code HR_LOCATIONS_ALL.POSTAL_CODE%TYPE;
2458: l_location_source VARCHAR2(4);
2459: l_inactive_date DATE;
2460:

Line 2457: l_postal_code HR_LOCATIONS_ALL.POSTAL_CODE%TYPE;

2453: terr_short_name FND_TERRITORIES_TL.TERRITORY_SHORT_NAME%TYPE;
2454: terr_code FND_TERRITORIES_TL.TERRITORY_CODE%TYPE;
2455: l_region HR_LOCATIONS_ALL.REGION_2%TYPE;
2456: l_city HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE;
2457: l_postal_code HR_LOCATIONS_ALL.POSTAL_CODE%TYPE;
2458: l_location_source VARCHAR2(4);
2459: l_inactive_date DATE;
2460:
2461: --Bug 6940375

Line 2475: hr_locations_all l,

2471: l.town_or_city city,
2472: l.postal_code,
2473: l.inactive_date
2474: FROM
2475: hr_locations_all l,
2476: fnd_territories_tl t
2477: WHERE
2478: t.territory_code = l.country and
2479: t.language = userenv('LANG') and

Line 2488: hr_locations_all l

2484: CURSOR Get_Internal_Loc IS
2485: SELECT
2486: l.location_id
2487: FROM
2488: hr_locations_all l
2489: WHERE
2490: l.location_id = p_location_id;
2491:
2492: --Bug 6940375