APPS.PAY_US_EMP_DT_TAX_RULES dependencies on PAY_US_STATES

Line 5576: from pay_us_states pus,

5572: and paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id;
5573:
5574: cursor csr_fed_or_def (p_tax_unit_id in number, p_state varchar2)is
5575: select hoi.org_information12
5576: from pay_us_states pus,
5577: hr_organization_information hoi
5578: where hoi.organization_id = p_tax_unit_id
5579: and hoi.org_information_context = 'State Tax Rules'
5580: and pus.state_code = p_state

Line 6641: PAY_US_STATES pus1,

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

Line 6644: PAY_US_STATES pus,

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

Line 9452: from PAY_US_STATES pus,

9448: p_ret_text in out nocopy varchar2) is
9449:
9450: cursor csr_get_loc_state is
9451: select pus.state_code
9452: from PAY_US_STATES pus,
9453: HR_LOCATIONS hrl
9454: where hrl.location_id = p_new_location_id
9455: and pus.state_abbrev = nvl(hrl.loc_information17,hrl.region_2);
9456:

Line 10759: pay_us_states pus,

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

Line 11367: pay_us_states pus,

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

Line 11398: pay_us_states pus,

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

Line 11464: from pay_us_states pus,

11460: and ftr.effective_end_date >= p_min_date;
11461:
11462: cursor csr_loc_state_code(p_location_id NUMBER) is
11463: select pus.state_code
11464: from pay_us_states pus,
11465: hr_locations hl
11466: where hl.location_id = p_location_id
11467: and pus.state_abbrev = nvl(loc_information17,region_2);
11468:

Line 11473: l_loc_state_code pay_us_states.state_code%TYPE;

11469: /* end modifications - dscully 20-jul-2000*/
11470:
11471: l_loc_min_date date;
11472: l_loc_max_date date;
11473: l_loc_state_code pay_us_states.state_code%TYPE;
11474:
11475:
11476: l_add_state_code varchar2(2);
11477: l_add_county_code varchar2(3);