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 PER_ADDRESSES

Line 76: from per_addresses pa,

72: and county_code = p_county_code;
73:
74: cursor c_get_emp_cities is
75: select town_or_city
76: from per_addresses pa,
77: pay_us_states pus,
78: pay_us_counties puc
79: where pus.state_abbrev = pa.region_2
80: and pus.state_code = puc.state_code

Line 87: from per_addresses pa,

83: and pus.state_code = p_state_code
84: and puc.county_code = p_county_code
85: union
86: select pa.add_information18
87: from per_addresses pa,
88: pay_us_states pus,
89: pay_us_counties puc
90: where pus.state_abbrev = pa.add_information17
91: and pus.state_code = puc.state_code

Line 3737: UPDATE per_addresses

3733: IF G_MODE = 'UPGRADE' THEN
3734:
3735: l_count := 0;
3736:
3737: UPDATE per_addresses
3738: SET region_1 = l_county_name_change.new_county_name
3739: WHERE region_1 = l_county_name_change.old_county_name
3740: AND region_2 = l_county_name_change.state_abbrev
3741: AND country = l_county_name_change.country;

Line 3745: UPDATE per_addresses

3741: AND country = l_county_name_change.country;
3742:
3743: l_count := SQL%ROWCOUNT;
3744:
3745: UPDATE per_addresses
3746: SET add_information19 = l_county_name_change.new_county_name
3747: WHERE add_information19 = l_county_name_change.old_county_name
3748: AND add_information17 = l_county_name_change.state_abbrev;
3749:

Line 3760: FROM per_addresses

3756: l_count := 0;
3757: l_override_count := 0;
3758:
3759: SELECT count(*) INTO l_count
3760: FROM per_addresses
3761: WHERE region_1 = l_county_name_change.old_county_name
3762: AND region_2 = l_county_name_change.state_abbrev
3763: AND country = l_county_name_change.country;
3764:

Line 3766: FROM per_addresses

3762: AND region_2 = l_county_name_change.state_abbrev
3763: AND country = l_county_name_change.country;
3764:
3765: SELECT count(*) INTO l_override_count
3766: FROM per_addresses
3767: WHERE add_information19 = l_county_name_change.old_county_name
3768: AND add_information17 = l_county_name_change.state_abbrev;
3769:
3770: l_count := l_count + l_override_count;

Line 3796: p_location => 'PER_ADDRESSES',

3792: p_person_id => null,
3793: p_assign_id => null,
3794: p_old_juri_code => null,
3795: p_new_juri_code => l_count,
3796: p_location => 'PER_ADDRESSES',
3797: p_id => p_geo_phase_id,
3798: p_description => l_description);
3799:
3800: END IF; /* l_count > 0 if*/

Line 4059: 'PER_ADDRESSES',

4055: SELECT DISTINCT
4056: p_geo_phase_id,
4057: NULL,
4058: pa.person_id,
4059: 'PER_ADDRESSES',
4060: pa.address_id,
4061: l_jurisdiction_code,
4062: l_jurisdiction_code,
4063: 'CY',

Line 4068: FROM per_addresses pa

4064: sysdate,
4065: p_mode,
4066: NULL,
4067: 'Address'||':'||l_city_name_change.old_city_name
4068: FROM per_addresses pa
4069: WHERE town_or_city = l_city_name_change.old_city_name
4070: AND region_1 = l_county_name
4071: AND NVL(region_2,l_city_name_change.state_abbrev) =
4072: DECODE(country,'US',l_city_name_change.state_abbrev,NVL(region_2,l_city_name_change.state_abbrev))

Line 4075: UPDATE per_addresses

4071: AND NVL(region_2,l_city_name_change.state_abbrev) =
4072: DECODE(country,'US',l_city_name_change.state_abbrev,NVL(region_2,l_city_name_change.state_abbrev))
4073: AND country = l_city_name_change.country;
4074:
4075: UPDATE per_addresses
4076: SET town_or_city = l_city_name_change.new_city_name,
4077: derived_locale = replace(derived_locale,
4078: l_city_name_change.old_city_name,
4079: l_city_name_change.new_city_name)

Line 4107: 'PER_ADDRESSES',

4103: SELECT DISTINCT
4104: p_geo_phase_id,
4105: NULL,
4106: pa.person_id,
4107: 'PER_ADDRESSES',
4108: pa.address_id,
4109: l_jurisdiction_code,
4110: l_jurisdiction_code,
4111: 'CY',

Line 4116: FROM per_addresses pa

4112: sysdate,
4113: p_mode,
4114: NULL,
4115: 'Taxation Address'||':'||l_city_name_change.old_city_name
4116: FROM per_addresses pa
4117: WHERE add_information18 = l_city_name_change.old_city_name
4118: AND add_information19 = l_county_name
4119: AND add_information17 = l_city_name_change.state_abbrev;
4120:

Line 4121: UPDATE per_addresses

4117: WHERE add_information18 = l_city_name_change.old_city_name
4118: AND add_information19 = l_county_name
4119: AND add_information17 = l_city_name_change.state_abbrev;
4120:
4121: UPDATE per_addresses
4122: SET add_information18 = l_city_name_change.new_city_name
4123: WHERE add_information18 = l_city_name_change.old_city_name
4124: AND add_information19 = l_county_name
4125: AND add_information17 = l_city_name_change.state_abbrev;

Line 4289: 'PER_ADDRESSES',

4285: SELECT DISTINCT
4286: p_geo_phase_id,
4287: NULL,
4288: pa.person_id,
4289: 'PER_ADDRESSES',
4290: pa.address_id,
4291: l_jurisdiction_code,
4292: l_jurisdiction_code,
4293: 'CY',

Line 4298: FROM per_addresses pa

4294: sysdate,
4295: p_mode,
4296: NULL,
4297: 'Address'||':'||l_city_name_change.old_city_name
4298: FROM per_addresses pa
4299: WHERE town_or_city = l_city_name_change.old_city_name
4300: AND region_1 = l_county_name
4301: AND NVL(region_2,l_city_name_change.state_abbrev) =
4302: DECODE(country,'US',l_city_name_change.state_abbrev,NVL(region_2,l_city_name_change.state_abbrev))

Line 4326: 'PER_ADDRESSES',

4322: SELECT DISTINCT
4323: p_geo_phase_id,
4324: NULL,
4325: pa.person_id,
4326: 'PER_ADDRESSES',
4327: pa.address_id,
4328: l_jurisdiction_code,
4329: l_jurisdiction_code,
4330: 'CY',

Line 4335: FROM per_addresses pa

4331: sysdate,
4332: p_mode,
4333: NULL,
4334: 'Taxation Address'||':'||l_city_name_change.old_city_name
4335: FROM per_addresses pa
4336: WHERE add_information18 = l_city_name_change.old_city_name
4337: AND add_information19 = l_county_name
4338: AND add_information17 = l_city_name_change.state_abbrev;
4339:

Line 4445: 'PER_ADDRESSES',

4441: SELECT DISTINCT
4442: p_geo_phase_id,
4443: NULL,
4444: pa.person_id,
4445: 'PER_ADDRESSES',
4446: pa.address_id,
4447: l_jurisdiction_code,
4448: l_jurisdiction_code,
4449: 'CY',

Line 4454: FROM per_addresses pa

4450: sysdate,
4451: p_mode,
4452: NULL,
4453: 'Address'||':'||l_city_name_change.old_city_name
4454: FROM per_addresses pa
4455: WHERE town_or_city = l_city_name_change.old_city_name
4456: AND region_1 = l_county_name
4457: AND NVL(region_2,l_city_name_change.state_abbrev) =
4458: DECODE(country,'US',l_city_name_change.state_abbrev,NVL(region_2,l_city_name_change.state_abbrev))

Line 4482: 'PER_ADDRESSES',

4478: SELECT DISTINCT
4479: p_geo_phase_id,
4480: NULL,
4481: pa.person_id,
4482: 'PER_ADDRESSES',
4483: pa.address_id,
4484: l_jurisdiction_code,
4485: l_jurisdiction_code,
4486: 'CY',

Line 4491: FROM per_addresses pa

4487: sysdate,
4488: p_mode,
4489: NULL,
4490: 'Taxation Address'||':'||l_city_name_change.old_city_name
4491: FROM per_addresses pa
4492: WHERE add_information18 = l_city_name_change.old_city_name
4493: AND add_information19 = l_county_name
4494: AND add_information17 = l_city_name_change.state_abbrev;
4495: