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.PAY_US_GEO_UPD_PKG dependencies on HR_LOCATIONS_ALL

Line 98: from hr_locations_all hl,

94: and pus.state_code = p_state_code
95: and puc.county_code = p_county_code
96: union
97: select hl.town_or_city
98: from hr_locations_all hl,
99: pay_us_states pus,
100: pay_us_counties puc
101: where pus.state_abbrev = hl.region_2
102: and pus.state_code = puc.state_code

Line 109: from hr_locations_all hl,

105: and pus.state_code = p_state_code
106: and puc.county_code = p_county_code
107: union
108: select loc_information18
109: from hr_locations_all hl,
110: pay_us_states pus,
111: pay_us_counties puc
112: where pus.state_abbrev = hl.loc_information17
113: and pus.state_code = puc.state_code

Line 3806: UPDATE hr_locations_all

3802: IF G_MODE = 'UPGRADE' THEN
3803:
3804: l_count := 0;
3805:
3806: UPDATE hr_locations_all
3807: SET region_1 = l_county_name_change.new_county_name
3808: WHERE region_1 = l_county_name_change.old_county_name
3809: AND region_2 = l_county_name_change.state_abbrev
3810: AND country = l_county_name_change.country;

Line 3814: UPDATE hr_locations_all

3810: AND country = l_county_name_change.country;
3811:
3812: l_count := SQL%ROWCOUNT;
3813:
3814: UPDATE hr_locations_all
3815: SET loc_information19 = l_county_name_change.new_county_name
3816: WHERE loc_information19 = l_county_name_change.old_county_name
3817: AND loc_information17 = l_county_name_change.state_abbrev;
3818:

Line 3829: FROM hr_locations_all

3825: l_count := 0;
3826: l_override_count := 0;
3827:
3828: SELECT count(*) INTO l_count
3829: FROM hr_locations_all
3830: WHERE region_1 = l_county_name_change.old_county_name
3831: AND region_2 = l_county_name_change.state_abbrev
3832: AND country = l_county_name_change.country;
3833:

Line 3835: FROM hr_locations_all

3831: AND region_2 = l_county_name_change.state_abbrev
3832: AND country = l_county_name_change.country;
3833:
3834: SELECT count(*) INTO l_override_count
3835: FROM hr_locations_all
3836: WHERE LOC_INFORMATION19 = l_county_name_change.old_county_name
3837: AND LOC_INFORMATION17 = l_county_name_change.state_abbrev;
3838:
3839: l_count := l_count + l_override_count;

Line 3865: p_location => 'HR_LOCATIONS_ALL',

3861: p_person_id => null,
3862: p_assign_id => null,
3863: p_old_juri_code => null,
3864: p_new_juri_code => l_count,
3865: p_location => 'HR_LOCATIONS_ALL',
3866: p_id => p_geo_phase_id,
3867: p_description => l_description);
3868:
3869: END IF; /* l_count > 0 if*/

Line 4150: 'HR_LOCATIONS_ALL',

4146: SELECT DISTINCT
4147: p_geo_phase_id,
4148: NULL,
4149: NULL,
4150: 'HR_LOCATIONS_ALL',
4151: hl.location_id,
4152: l_jurisdiction_code,
4153: l_jurisdiction_code,
4154: 'CY',

Line 4159: FROM hr_locations_all hl

4155: sysdate,
4156: p_mode,
4157: NULL,
4158: 'Address'||':'||l_city_name_change.old_city_name
4159: FROM hr_locations_all hl
4160: WHERE town_or_city = l_city_name_change.old_city_name
4161: AND region_1 = l_county_name
4162: AND NVL(region_2,l_city_name_change.state_abbrev) =
4163: DECODE(country,'US',l_city_name_change.state_abbrev,NVL(region_2,l_city_name_change.state_abbrev))

Line 4166: UPDATE hr_locations_all

4162: AND NVL(region_2,l_city_name_change.state_abbrev) =
4163: DECODE(country,'US',l_city_name_change.state_abbrev,NVL(region_2,l_city_name_change.state_abbrev))
4164: AND country = l_city_name_change.country;
4165:
4166: UPDATE hr_locations_all
4167: SET town_or_city = l_city_name_change.new_city_name,
4168: derived_locale = replace(derived_locale,
4169: l_city_name_change.old_city_name,
4170: l_city_name_change.new_city_name)

Line 4198: 'HR_LOCATIONS_ALL',

4194: SELECT DISTINCT
4195: p_geo_phase_id,
4196: NULL,
4197: NULL,
4198: 'HR_LOCATIONS_ALL',
4199: hl.location_id,
4200: l_jurisdiction_code,
4201: l_jurisdiction_code,
4202: 'CY',

Line 4207: FROM hr_locations_all hl

4203: sysdate,
4204: p_mode,
4205: NULL,
4206: 'Payroll Tax Address'||':'||l_city_name_change.old_city_name
4207: FROM hr_locations_all hl
4208: WHERE loc_information18 = l_city_name_change.old_city_name
4209: AND loc_information19 = l_county_name
4210: AND loc_information17 = l_city_name_change.state_abbrev;
4211:

Line 4212: UPDATE hr_locations_all

4208: WHERE loc_information18 = l_city_name_change.old_city_name
4209: AND loc_information19 = l_county_name
4210: AND loc_information17 = l_city_name_change.state_abbrev;
4211:
4212: UPDATE hr_locations_all
4213: SET loc_information18 = l_city_name_change.new_city_name
4214: WHERE loc_information18 = l_city_name_change.old_city_name
4215: AND loc_information19 = l_county_name
4216: AND loc_information17 = l_city_name_change.state_abbrev;

Line 4361: 'HR_LOCATIONS_ALL',

4357: SELECT DISTINCT
4358: p_geo_phase_id,
4359: NULL,
4360: NULL,
4361: 'HR_LOCATIONS_ALL',
4362: hl.location_id,
4363: l_jurisdiction_code,
4364: l_jurisdiction_code,
4365: 'CY',

Line 4370: FROM hr_locations_all hl

4366: sysdate,
4367: p_mode,
4368: NULL,
4369: 'Address'||':'||l_city_name_change.old_city_name
4370: FROM hr_locations_all hl
4371: WHERE town_or_city = l_city_name_change.old_city_name
4372: AND region_1 = l_county_name
4373: AND NVL(region_2,l_city_name_change.state_abbrev) =
4374: DECODE(country,'US',l_city_name_change.state_abbrev,NVL(region_2,l_city_name_change.state_abbrev))

Line 4398: 'HR_LOCATIONS_ALL',

4394: SELECT DISTINCT
4395: p_geo_phase_id,
4396: NULL,
4397: NULL,
4398: 'HR_LOCATIONS_ALL',
4399: hl.location_id,
4400: l_jurisdiction_code,
4401: l_jurisdiction_code,
4402: 'CY',

Line 4407: FROM hr_locations_all hl

4403: sysdate,
4404: p_mode,
4405: NULL,
4406: 'Payroll Tax Address'||':'||l_city_name_change.old_city_name
4407: FROM hr_locations_all hl
4408: WHERE loc_information18 = l_city_name_change.old_city_name
4409: AND loc_information19 = l_county_name
4410: AND loc_information17 = l_city_name_change.state_abbrev;
4411:

Line 4517: 'HR_LOCATIONS_ALL',

4513: SELECT DISTINCT
4514: p_geo_phase_id,
4515: NULL,
4516: NULL,
4517: 'HR_LOCATIONS_ALL',
4518: hl.location_id,
4519: l_jurisdiction_code,
4520: l_jurisdiction_code,
4521: 'CY',

Line 4526: FROM hr_locations_all hl

4522: sysdate,
4523: p_mode,
4524: NULL,
4525: 'Address'||':'||l_city_name_change.old_city_name
4526: FROM hr_locations_all hl
4527: WHERE town_or_city = l_city_name_change.old_city_name
4528: AND region_1 = l_county_name
4529: AND NVL(region_2,l_city_name_change.state_abbrev) =
4530: DECODE(country,'US',l_city_name_change.state_abbrev,NVL(region_2,l_city_name_change.state_abbrev))

Line 4554: 'HR_LOCATIONS_ALL',

4550: SELECT DISTINCT
4551: p_geo_phase_id,
4552: NULL,
4553: NULL,
4554: 'HR_LOCATIONS_ALL',
4555: hl.location_id,
4556: l_jurisdiction_code,
4557: l_jurisdiction_code,
4558: 'CY',

Line 4563: FROM hr_locations_all hl

4559: sysdate,
4560: p_mode,
4561: NULL,
4562: 'Payroll Tax Address'||':'||l_city_name_change.old_city_name
4563: FROM hr_locations_all hl
4564: WHERE loc_information18 = l_city_name_change.old_city_name
4565: AND loc_information19 = l_county_name
4566: AND loc_information17 = l_city_name_change.state_abbrev;
4567: