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_AC_UTILITY dependencies on PAY_US_STATES

Line 441: from pay_us_states

437: RETURN VARCHAR2
438: IS
439: cursor c_state_code(cp_state_abbrev in varchar2) is
440: select state_code || '-000-0000'
441: from pay_us_states
442: where state_abbrev = cp_state_abbrev;
443:
444: cursor c_county_code(cp_state_abbrev in varchar2
445: ,cp_county_name in varchar2) is

Line 447: from pay_us_states pus,

443:
444: cursor c_county_code(cp_state_abbrev in varchar2
445: ,cp_county_name in varchar2) is
446: select puc.state_code || '-' || puc.county_code || '-0000'
447: from pay_us_states pus,
448: pay_us_counties puc
449: where pus.state_abbrev = cp_state_abbrev
450: and puc.state_code = pus.state_code
451: and puc.county_name = cp_county_name;