[Home] [Help]
6626: corresponding to a location id */
6627: /* lwthomps .. While we only want to create tax records for the
6628: primary cities, locations can corespond to vanity or secondary
6629: cities that share the same geocode. For this reason I am removing
6630: the join to pay_us_city_names for primary = 'Y' (588982) */
6631:
6632: cursor csr_get_codes(p_location number) is
6633: select pus.state_code,
6634: puco.county_code,
6635: puci.city_code,
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,
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,
6645: HR_LOCATIONS hrl
6646: where hrl.location_id = p_location
10753: cursor csr_chk_addr_ovrd is
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
11361: cursor csr_chk_addr_ovrd(p_assignment number) is
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
11392: cursor csr_chk_addr_ovrd_2(p_assignment number,p_effective_start_date date ) is
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