APPS.PAY_US_EMP_DT_TAX_RULES dependencies on PAY_US_COUNTIES

Line 6564: PAY_US_COUNTIES puco1,

6560: pus1.state_code,
6561: puco1.county_code,
6562: puci1.city_code
6563: from PAY_US_CITY_NAMES puci1,
6564: PAY_US_COUNTIES puco1,
6565: PAY_US_STATES pus1,
6566: PAY_US_CITY_NAMES puci,
6567: PAY_US_COUNTIES puco,
6568: PAY_US_STATES pus,

Line 6567: PAY_US_COUNTIES puco,

6563: from PAY_US_CITY_NAMES puci1,
6564: PAY_US_COUNTIES puco1,
6565: PAY_US_STATES pus1,
6566: PAY_US_CITY_NAMES puci,
6567: PAY_US_COUNTIES puco,
6568: PAY_US_STATES pus,
6569: HR_LOCATIONS hrl
6570: where hrl.location_id = p_location
6571: and pus.state_abbrev = hrl.region_2

Line 10682: pay_us_counties puc,

10678: select pus.state_code,
10679: puc.county_code,
10680: pcn.city_code
10681: from pay_us_city_names pcn,
10682: pay_us_counties puc,
10683: pay_us_states pus,
10684: per_addresses pa,
10685: per_assignments_f paf
10686: where paf.assignment_id = p_assignment_id

Line 11290: pay_us_counties puc,

11286: select pus.state_code,
11287: puc.county_code,
11288: pcn.city_code
11289: from pay_us_city_names pcn,
11290: pay_us_counties puc,
11291: pay_us_states pus,
11292: per_addresses pa,
11293: per_assignments_f paf
11294: where paf.assignment_id = p_assignment

Line 11321: pay_us_counties puc,

11317: select pus.state_code,
11318: puc.county_code,
11319: pcn.city_code
11320: from pay_us_city_names pcn,
11321: pay_us_counties puc,
11322: pay_us_states pus,
11323: per_addresses pa,
11324: per_assignments_f paf
11325: where paf.assignment_id = p_assignment