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_COUNTIES

Line 240: from pay_us_counties

236: --
237: --
238: cursor csr_valid_county_code is
239: select county_code
240: from pay_us_counties
241: where state_code = p_state_code
242: and county_code = p_county_code;
243: --
244: begin

Line 1155: pay_us_counties puc,

1151: and hrl.location_id = paf.location_id
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

Line 1183: pay_us_counties puco,

1179: and pa.primary_flag = 'Y'
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