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 446: hr_locations hl,

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

Line 2852: l_tax_location_id hr_locations.location_id%TYPE;

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

Line 3316: l_tax_location_id hr_locations.location_id%TYPE;

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

Line 3693: from hr_locations loc

3689: and asg.effective_end_date;
3690: --
3691: cursor csr_chk_location_id is
3692: select null
3693: from hr_locations loc
3694: where loc.location_id = p_location_id;
3695: --
3696: cursor csr_fed_rec1(l_csr_assignment_id number
3697: ,l_csr_start_date date

Line 5219: l_tmp_loc_id hr_locations.location_id%TYPE;

5215: --
5216: l_proc varchar2(72) := g_package||'move_tax_default_date';
5217: l_effective_date date;
5218: l_new_hire_date date;
5219: l_tmp_loc_id hr_locations.location_id%TYPE;
5220: l_new_location_id hr_locations.location_id%TYPE;
5221: l_temp_char varchar2(10);
5222: l_tmp_effective_start_date
5223: pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;

Line 5220: l_new_location_id hr_locations.location_id%TYPE;

5216: l_proc varchar2(72) := g_package||'move_tax_default_date';
5217: l_effective_date date;
5218: l_new_hire_date date;
5219: l_tmp_loc_id hr_locations.location_id%TYPE;
5220: l_new_location_id hr_locations.location_id%TYPE;
5221: l_temp_char varchar2(10);
5222: l_tmp_effective_start_date
5223: pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
5224: l_tmp_effective_end_date pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;