APPS.PAY_US_EMP_DT_TAX_RULES dependencies on PAY_US_STATES

Line 5500: from pay_us_states pus,

5496: and paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id;
5497:
5498: cursor csr_fed_or_def (p_tax_unit_id in number, p_state varchar2)is
5499: select hoi.org_information12
5500: from pay_us_states pus,
5501: hr_organization_information hoi
5502: where hoi.organization_id = p_tax_unit_id
5503: and hoi.org_information_context = 'State Tax Rules'
5504: and pus.state_code = p_state

Line 6565: PAY_US_STATES pus1,

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,
6569: HR_LOCATIONS hrl

Line 6568: PAY_US_STATES pus,

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
6572: and puco.state_code = pus.state_code

Line 9376: from PAY_US_STATES pus,

9372: p_ret_text in out nocopy varchar2) is
9373:
9374: cursor csr_get_loc_state is
9375: select pus.state_code
9376: from PAY_US_STATES pus,
9377: HR_LOCATIONS hrl
9378: where hrl.location_id = p_new_location_id
9379: and pus.state_abbrev = nvl(hrl.loc_information17,hrl.region_2);
9380:

Line 10683: pay_us_states pus,

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
10687: and p_effective_start_date between paf.effective_start_date and

Line 11291: pay_us_states pus,

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
11295: and p_effective_start_date between paf.effective_start_date and

Line 11322: pay_us_states pus,

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
11326: and p_effective_start_date between paf.effective_start_date and

Line 11388: from pay_us_states pus,

11384: and ftr.effective_end_date >= p_min_date;
11385:
11386: cursor csr_loc_state_code(p_location_id NUMBER) is
11387: select pus.state_code
11388: from pay_us_states pus,
11389: hr_locations hl
11390: where hl.location_id = p_location_id
11391: and pus.state_abbrev = nvl(loc_information17,region_2);
11392:

Line 11397: l_loc_state_code pay_us_states.state_code%TYPE;

11393: /* end modifications - dscully 20-jul-2000*/
11394:
11395: l_loc_min_date date;
11396: l_loc_max_date date;
11397: l_loc_state_code pay_us_states.state_code%TYPE;
11398:
11399:
11400: l_add_state_code varchar2(2);
11401: l_add_county_code varchar2(3);