eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_US_TAX_INTERNAL dependencies on HR_LOCATIONS

Line 35: from hr_locations loc

31:
32: cursor csr_loc_addr(p_lc_id number) is
33: select sta.state_code, cnt.county_code, cty.city_code,
34: sta2.state_code, cnt2.county_code, cty2.city_code
35: from hr_locations loc
36: ,pay_us_states sta
37: ,pay_us_counties cnt
38: ,pay_us_city_names cty
39: ,pay_us_states sta2

Line 448: hr_locations hl,

444: INDEX(PAF PER_ASSIGNMENTS_F_PK)
445: USE_NL(PAF, HL, PUS, PUC, PUCN) */
446: pus.state_code ||'-'|| puc.county_code ||'-'|| pucn.city_code
447: from per_assignments_f paf,
448: hr_locations hl,
449: pay_us_states pus,
450: pay_us_counties puc,
451: pay_us_city_names pucn
452: where paf.assignment_id = l_assignment_id

Line 2854: l_tax_location_id hr_locations.location_id%TYPE;

2850: l_res_ovrd_state_code pay_us_states.state_code%TYPE;
2851: l_res_ovrd_county_code pay_us_counties.county_code%TYPE;
2852: l_res_ovrd_city_code pay_us_city_names.city_code%TYPE;
2853:
2854: l_tax_location_id hr_locations.location_id%TYPE;
2855: l_tax_loc_state_code pay_us_states.state_code%TYPE;
2856: l_tax_loc_ovrd_state_code pay_us_states.state_code%TYPE;
2857: l_tax_loc_county_code pay_us_counties.county_code%TYPE;
2858: l_tax_loc_ovrd_county_code pay_us_counties.county_code%TYPE;

Line 3318: l_tax_location_id hr_locations.location_id%TYPE;

3314: l_fed_object_version_number
3315: pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
3316: l_fed_eff_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
3317: l_fed_eff_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
3318: l_tax_location_id hr_locations.location_id%TYPE;
3319: l_tax_loc_state_code pay_us_states.state_code%TYPE;
3320: l_tax_loc_county_code pay_us_counties.county_code%TYPE;
3321: l_tax_loc_city_code pay_us_city_names.city_code%TYPE;
3322: l_tax_loc_ovrd_state_code pay_us_states.state_code%TYPE;

Line 3777: from hr_locations loc

3773: and asg.effective_end_date;
3774: --
3775: cursor csr_chk_location_id is
3776: select null
3777: from hr_locations loc
3778: where loc.location_id = p_location_id;
3779: --
3780: cursor csr_fed_rec1(l_csr_assignment_id number
3781: ,l_csr_start_date date

Line 5303: l_tmp_loc_id hr_locations.location_id%TYPE;

5299: --
5300: l_proc varchar2(72) := g_package||'move_tax_default_date';
5301: l_effective_date date;
5302: l_new_hire_date date;
5303: l_tmp_loc_id hr_locations.location_id%TYPE;
5304: l_new_location_id hr_locations.location_id%TYPE;
5305: l_temp_char varchar2(10);
5306: l_tmp_effective_start_date
5307: pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;

Line 5304: l_new_location_id hr_locations.location_id%TYPE;

5300: l_proc varchar2(72) := g_package||'move_tax_default_date';
5301: l_effective_date date;
5302: l_new_hire_date date;
5303: l_tmp_loc_id hr_locations.location_id%TYPE;
5304: l_new_location_id hr_locations.location_id%TYPE;
5305: l_temp_char varchar2(10);
5306: l_tmp_effective_start_date
5307: pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
5308: l_tmp_effective_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;