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.HR_LOCATION_RECORD dependencies on HR_LOCATIONS

Line 6: CURSOR c_location(p_location_id hr_locations.location_id%TYPE

2: /* $Header: hrlocqry.pkb 120.0.12010000.4 2009/01/22 09:45:52 srgnanas noship $ */
3: PROCEDURE get_location_details(p_query_options IN location_input_rectype
4: ,p_locations OUT NOCOPY location_tabletype)
5: IS
6: CURSOR c_location(p_location_id hr_locations.location_id%TYPE
7: ,p_start_location_id hr_locations.location_id%TYPE
8: ,p_end_location_id hr_locations.location_id%TYPE
9: ,p_bg_id hr_locations.business_group_id%TYPE) IS
10: SELECT loc.location_id,

Line 7: ,p_start_location_id hr_locations.location_id%TYPE

3: PROCEDURE get_location_details(p_query_options IN location_input_rectype
4: ,p_locations OUT NOCOPY location_tabletype)
5: IS
6: CURSOR c_location(p_location_id hr_locations.location_id%TYPE
7: ,p_start_location_id hr_locations.location_id%TYPE
8: ,p_end_location_id hr_locations.location_id%TYPE
9: ,p_bg_id hr_locations.business_group_id%TYPE) IS
10: SELECT loc.location_id,
11: lot.location_code,

Line 8: ,p_end_location_id hr_locations.location_id%TYPE

4: ,p_locations OUT NOCOPY location_tabletype)
5: IS
6: CURSOR c_location(p_location_id hr_locations.location_id%TYPE
7: ,p_start_location_id hr_locations.location_id%TYPE
8: ,p_end_location_id hr_locations.location_id%TYPE
9: ,p_bg_id hr_locations.business_group_id%TYPE) IS
10: SELECT loc.location_id,
11: lot.location_code,
12: 'HR',

Line 9: ,p_bg_id hr_locations.business_group_id%TYPE) IS

5: IS
6: CURSOR c_location(p_location_id hr_locations.location_id%TYPE
7: ,p_start_location_id hr_locations.location_id%TYPE
8: ,p_end_location_id hr_locations.location_id%TYPE
9: ,p_bg_id hr_locations.business_group_id%TYPE) IS
10: SELECT loc.location_id,
11: lot.location_code,
12: 'HR',
13: loc.business_group_id + 0 business_group_id,

Line 99: FROM hr_locations_all loc,

95: loc.ece_tp_location_code,
96: loc.object_version_number,
97: loc.legal_address_flag,
98: loc.timezone_code
99: FROM hr_locations_all loc,
100: hr_locations_all_tl lot
101: WHERE nvl(p_location_id, loc.LOCATION_ID) = loc.LOCATION_ID
102: AND loc.LOCATION_ID BETWEEN nvl(p_start_location_id, loc.LOCATION_ID)
103: AND nvl(p_end_location_id, loc.LOCATION_ID)

Line 100: hr_locations_all_tl lot

96: loc.object_version_number,
97: loc.legal_address_flag,
98: loc.timezone_code
99: FROM hr_locations_all loc,
100: hr_locations_all_tl lot
101: WHERE nvl(p_location_id, loc.LOCATION_ID) = loc.LOCATION_ID
102: AND loc.LOCATION_ID BETWEEN nvl(p_start_location_id, loc.LOCATION_ID)
103: AND nvl(p_end_location_id, loc.LOCATION_ID)
104: AND ((p_bg_id IS NULL) OR (p_bg_id IS NOT NULL AND p_bg_id = loc.BUSINESS_GROUP_ID))