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 PAY_US_STATES

Line 77: pay_us_states pus,

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
81: and nvl(p_county_name,puc.county_name) = pa.region_1

Line 88: pay_us_states pus,

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
92: and nvl(p_county_name,puc.county_name) = pa.add_information19

Line 99: pay_us_states pus,

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
103: and nvl(p_county_name,puc.county_name) = hl.region_1

Line 110: pay_us_states pus,

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
114: and nvl(p_county_name,puc.county_name) = hl.loc_information19

Line 235: pay_us_states pus

231: sqlstr := ' select distinct paf.person_id
232: from pay_us_modified_geocodes mg,
233: pay_us_emp_city_tax_rules_f tr,
234: per_all_assignments_f paf,
235: pay_us_states pus
236: where mg.patch_name = '''||ln_upgrade_patch||'''
237: and mg.state_code = pus.state_code
238: and mg.state_code = tr.state_code
239: and mg.county_code = tr.county_code

Line 2682: FROM pay_us_states pus,

2678: SELECT pus.state_code,
2679: pus.state_name,
2680: pusf.effective_start_date,
2681: pusf.effective_end_date
2682: FROM pay_us_states pus,
2683: pay_us_emp_state_tax_rules_f pusf
2684: WHERE pusf.assignment_id = p_assign_id
2685: AND pusf.state_code = pus.state_abbrev
2686: AND NOT EXISTS (select 'Y' from PAY_US_GEO_UPDATE pugu

Line 3705: pay_us_states pus,

3701: puc.county_code,
3702: pumg.city_name old_county_name,
3703: puc.county_name new_county_name
3704: FROM pay_us_modified_geocodes pumg,
3705: pay_us_states pus,
3706: pay_us_counties puc
3707: WHERE pus.state_code = puc.state_code
3708: AND pus.state_code = pumg.state_code
3709: AND puc.county_code = pumg.county_code

Line 3972: pay_us_states pus,

3968: pumg1.city_name old_city_name,
3969: pumg2.city_name new_city_name
3970: FROM pay_us_modified_geocodes pumg1,
3971: pay_us_modified_geocodes pumg2,
3972: pay_us_states pus,
3973: pay_us_counties puc
3974: WHERE pus.state_code = puc.state_code
3975: AND pus.state_code = pumg1.state_code
3976: AND pus.state_code = pumg2.state_code