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_ACTION_ARCH dependencies on PAY_US_COUNTIES

Line 3363: pay_us_counties puc,

3359: ,cp_county_name in varchar2
3360: ,cp_city_name in varchar2) is
3361: select pcn.state_code, pcn.county_code, pcn.city_code
3362: from pay_us_states pus,
3363: pay_us_counties puc,
3364: pay_us_city_names pcn
3365: where pus.state_abbrev = cp_state_abbrev
3366: and puc.state_code = pus.state_code
3367: and puc.county_name = cp_county_name

Line 6434: from pay_us_counties

6430: date_ear between effective_start_date and effective_end_date;
6431:
6432: cursor cnty_name (jur_code varchar2) IS
6433: select county_name
6434: from pay_us_counties
6435: where state_code = substr(jur_code,1,2) and
6436: county_code = substr(jur_code,4,3);
6437:
6438: -- Added for bug 14098797