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

Line 3563: l_city_name pay_us_city_names.city_name%type;

3559: l_county_sd_uei ff_user_entities.user_entity_id%type;
3560: l_city_sd_uei ff_user_entities.user_entity_id%type;
3561: l_state_abbrev pay_us_states.state_abbrev%type;
3562: l_county_name pay_us_counties.county_name%type;
3563: l_city_name pay_us_city_names.city_name%type;
3564: l_cnt_sd_name pay_us_county_school_dsts.school_dst_name%type;
3565: l_cty_sd_name pay_us_city_school_dsts.school_dst_name%type;
3566: l_step number := 0;
3567: l_county_code varchar2(3);

Line 4100: from pay_us_city_names pcn

4096: hr_utility.trace('Getting City Name from DB');
4097:
4098: select city_name
4099: into l_city_name
4100: from pay_us_city_names pcn
4101: where pcn.state_code = substr(l_jurisdiction,1,2)
4102: and pcn.county_code = substr(l_jurisdiction,4,3)
4103: and pcn.city_code = substr(l_jurisdiction,8,4)
4104: and pcn.primary_flag = 'Y';