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.

[Home] [Help]

APPS.PAY_US_EMP_DT_TAX_RULES dependencies on PAY_US_CITY_NAMES

Line 6554: the join to pay_us_city_names for primary = 'Y' (588982) */

6550: corresponding to a location id */
6551: /* lwthomps .. While we only want to create tax records for the
6552: primary cities, locations can corespond to vanity or secondary
6553: cities that share the same geocode. For this reason I am removing
6554: the join to pay_us_city_names for primary = 'Y' (588982) */
6555:
6556: cursor csr_get_codes(p_location number) is
6557: select pus.state_code,
6558: puco.county_code,

Line 6563: from PAY_US_CITY_NAMES puci1,

6559: puci.city_code,
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,

Line 6566: PAY_US_CITY_NAMES puci,

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,
6569: HR_LOCATIONS hrl
6570: where hrl.location_id = p_location

Line 10681: from pay_us_city_names pcn,

10677: cursor csr_chk_addr_ovrd is
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

Line 11289: from pay_us_city_names pcn,

11285: cursor csr_chk_addr_ovrd(p_assignment number) is
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

Line 11320: from pay_us_city_names pcn,

11316: cursor csr_chk_addr_ovrd_2(p_assignment number,p_effective_start_date date ) is
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