APPS.PAY_US_EMP_DT_TAX_RULES dependencies on PAY_US_COUNTIES

Line 6640: PAY_US_COUNTIES puco1,

6636: pus1.state_code,
6637: puco1.county_code,
6638: puci1.city_code
6639: from PAY_US_CITY_NAMES puci1,
6640: PAY_US_COUNTIES puco1,
6641: PAY_US_STATES pus1,
6642: PAY_US_CITY_NAMES puci,
6643: PAY_US_COUNTIES puco,
6644: PAY_US_STATES pus,

Line 6643: PAY_US_COUNTIES puco,

6639: from PAY_US_CITY_NAMES puci1,
6640: PAY_US_COUNTIES puco1,
6641: PAY_US_STATES pus1,
6642: PAY_US_CITY_NAMES puci,
6643: PAY_US_COUNTIES puco,
6644: PAY_US_STATES pus,
6645: HR_LOCATIONS hrl
6646: where hrl.location_id = p_location
6647: and pus.state_abbrev = hrl.region_2

Line 10758: pay_us_counties puc,

10754: select pus.state_code,
10755: puc.county_code,
10756: pcn.city_code
10757: from pay_us_city_names pcn,
10758: pay_us_counties puc,
10759: pay_us_states pus,
10760: per_addresses pa,
10761: per_assignments_f paf
10762: where paf.assignment_id = p_assignment_id

Line 11366: pay_us_counties puc,

11362: select pus.state_code,
11363: puc.county_code,
11364: pcn.city_code
11365: from pay_us_city_names pcn,
11366: pay_us_counties puc,
11367: pay_us_states pus,
11368: per_addresses pa,
11369: per_assignments_f paf
11370: where paf.assignment_id = p_assignment

Line 11397: pay_us_counties puc,

11393: select pus.state_code,
11394: puc.county_code,
11395: pcn.city_code
11396: from pay_us_city_names pcn,
11397: pay_us_counties puc,
11398: pay_us_states pus,
11399: per_addresses pa,
11400: per_assignments_f paf
11401: where paf.assignment_id = p_assignment