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_CTY_BUS dependencies on PAY_US_CITY_NAMES

Line 393: from pay_us_city_names

389: --
390: --
391: cursor csr_valid_jurisdiction_code is
392: select count(*)
393: from pay_us_city_names
394: where state_code = p_state_code
395: and county_code = p_county_code
396: and city_code = p_city_code;
397: --

Line 1156: pay_us_city_names pucn

1152: and paf.effective_end_date > p_csr_tmp_date
1153: and exists (select null
1154: from pay_us_states pus,
1155: pay_us_counties puc,
1156: pay_us_city_names pucn
1157: where pus.state_abbrev = hrl.region_2
1158: and pus.state_code = p_state_code
1159: and puc.state_code = pus.state_code
1160: and puc.county_name = hrl.region_1

Line 1184: pay_us_city_names puci

1180: and nvl(pa.date_to, hr_api.g_eot) > p_csr_tmp_date
1181: and exists (select null
1182: from pay_us_states pus,
1183: pay_us_counties puco,
1184: pay_us_city_names puci
1185: where pus.state_abbrev = pa.region_2
1186: and pus.state_code = p_state_code
1187: and puco.state_code = pus.state_code
1188: and puco.county_name = pa.region_1