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

Line 349: lv_resident_city pay_us_city_names.city_name%TYPE;

345: lct_address_details get_address_details%ROWTYPE;
346:
347: lv_resident_state pay_us_states.state_abbrev%TYPE;
348: lv_resident_county pay_us_counties.county_name%TYPE;
349: lv_resident_city pay_us_city_names.city_name%TYPE;
350: lv_resident_zip_code pay_us_zip_codes.zip_start%TYPE;
351:
352: lv_datetrack_update_mode VARCHAR2(50) := 'CORRECTION';
353: ln_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;

Line 1192: pay_us_city_names pcn

1188: cp_city_name VARCHAR2) IS
1189: SELECT pcn.state_code||'-'||pcn.county_code||'-'||pcn.city_code
1190: FROM pay_us_states pus,
1191: pay_us_counties puc,
1192: pay_us_city_names pcn
1193: WHERE pus.state_abbrev = cp_state_abbrev
1194: AND puc.state_code = pus.state_code
1195: AND puc.county_name = cp_county_name
1196: AND pcn.state_code = puc.state_code

Line 2267: pay_us_city_names punc

2263: FROM per_all_assignments_f peaf,
2264: hr_locations_all hla,
2265: pay_us_states pus,
2266: pay_us_counties puc,
2267: pay_us_city_names punc
2268: WHERE peaf.assignment_id = p_assignment_id
2269: AND peaf.location_id = hla.location_id
2270: AND hla.region_2 = pus.state_abbrev
2271: AND pus.state_code = puc.state_code