APPS.PAY_US_EMP_DT_TAX_RULES dependencies on HR_LOCATIONS

Line 6645: HR_LOCATIONS hrl

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
6649: and puco.county_name = hrl.region_1

Line 9453: HR_LOCATIONS hrl

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:
9457: cursor csr_get_fed_rows is

Line 11465: hr_locations hl

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:
11469: /* end modifications - dscully 20-jul-2000*/

Line 11479: l_loc_id hr_locations.location_id%TYPE;

11475:
11476: l_add_state_code varchar2(2);
11477: l_add_county_code varchar2(3);
11478: l_add_city_code varchar2(4);
11479: l_loc_id hr_locations.location_id%TYPE;
11480:
11481: begin
11482:
11483: -- hr_utility.trace_on(null,'AMITA');