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 2471: l_region HR_LOCATIONS_ALL.REGION_2%TYPE;

2467: l_organization_id NUMBER;
2468: map_region BOOLEAN := FALSE;
2469: terr_short_name FND_TERRITORIES_TL.TERRITORY_SHORT_NAME%TYPE;
2470: terr_code FND_TERRITORIES_TL.TERRITORY_CODE%TYPE;
2471: l_region HR_LOCATIONS_ALL.REGION_2%TYPE;
2472: l_city HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE;
2473: l_postal_code HR_LOCATIONS_ALL.POSTAL_CODE%TYPE;
2474: l_location_source VARCHAR2(4);
2475: l_inactive_date DATE;

Line 2472: l_city HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE;

2468: map_region BOOLEAN := FALSE;
2469: terr_short_name FND_TERRITORIES_TL.TERRITORY_SHORT_NAME%TYPE;
2470: terr_code FND_TERRITORIES_TL.TERRITORY_CODE%TYPE;
2471: l_region HR_LOCATIONS_ALL.REGION_2%TYPE;
2472: l_city HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE;
2473: l_postal_code HR_LOCATIONS_ALL.POSTAL_CODE%TYPE;
2474: l_location_source VARCHAR2(4);
2475: l_inactive_date DATE;
2476:

Line 2473: l_postal_code HR_LOCATIONS_ALL.POSTAL_CODE%TYPE;

2469: terr_short_name FND_TERRITORIES_TL.TERRITORY_SHORT_NAME%TYPE;
2470: terr_code FND_TERRITORIES_TL.TERRITORY_CODE%TYPE;
2471: l_region HR_LOCATIONS_ALL.REGION_2%TYPE;
2472: l_city HR_LOCATIONS_ALL.TOWN_OR_CITY%TYPE;
2473: l_postal_code HR_LOCATIONS_ALL.POSTAL_CODE%TYPE;
2474: l_location_source VARCHAR2(4);
2475: l_inactive_date DATE;
2476:
2477: --Bug 6940375

Line 2491: hr_locations_all l,

2487: l.town_or_city city,
2488: l.postal_code,
2489: l.inactive_date
2490: FROM
2491: hr_locations_all l,
2492: fnd_territories_tl t
2493: WHERE
2494: t.territory_code = l.country and
2495: t.language = userenv('LANG') and

Line 2504: hr_locations_all l

2500: CURSOR Get_Internal_Loc IS
2501: SELECT
2502: l.location_id
2503: FROM
2504: hr_locations_all l
2505: WHERE
2506: l.location_id = p_location_id;
2507:
2508: --Bug 6940375