APPS.PAY_US_EMP_DT_TAX_RULES dependencies on HR_LOCATIONS

Line 6569: HR_LOCATIONS hrl

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

Line 9377: HR_LOCATIONS hrl

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

Line 11389: hr_locations hl

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

Line 11403: l_loc_id hr_locations.location_id%TYPE;

11399:
11400: l_add_state_code varchar2(2);
11401: l_add_county_code varchar2(3);
11402: l_add_city_code varchar2(4);
11403: l_loc_id hr_locations.location_id%TYPE;
11404:
11405: begin
11406:
11407: -- hr_utility.trace_on(null,'AMITA');