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 PAY_US_COUNTIES

Line 37: ,pay_us_counties cnt

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
40: ,pay_us_counties cnt2
41: ,pay_us_city_names cty2

Line 40: ,pay_us_counties cnt2

36: ,pay_us_states sta
37: ,pay_us_counties cnt
38: ,pay_us_city_names cty
39: ,pay_us_states sta2
40: ,pay_us_counties cnt2
41: ,pay_us_city_names cty2
42: where loc.location_id = p_lc_id
43: AND cnt.state_code = sta.state_code
44: AND loc.town_or_city = cty.city_name

Line 62: ,pay_us_counties cnt

58: select sta.state_code, cnt.county_code, cty.city_code,
59: sta2.state_code, cnt2.county_code, cty2.city_code
60: from per_addresses adr
61: ,pay_us_states sta
62: ,pay_us_counties cnt
63: ,pay_us_city_names cty
64: ,pay_us_states sta2
65: ,pay_us_counties cnt2
66: ,pay_us_city_names cty2

Line 65: ,pay_us_counties cnt2

61: ,pay_us_states sta
62: ,pay_us_counties cnt
63: ,pay_us_city_names cty
64: ,pay_us_states sta2
65: ,pay_us_counties cnt2
66: ,pay_us_city_names cty2
67: where adr.person_id = p_person_id
68: and adr.primary_flag = 'Y'
69: and p_effective_date between adr.date_from

Line 92: ,pay_us_counties cnt

88: select sta.state_code, cnt.county_code, cty.city_code,
89: sta2.state_code, cnt2.county_code, cty2.city_code
90: from per_addresses adr
91: ,pay_us_states sta
92: ,pay_us_counties cnt
93: ,pay_us_city_names cty
94: ,pay_us_states sta2
95: ,pay_us_counties cnt2
96: ,pay_us_city_names cty2

Line 95: ,pay_us_counties cnt2

91: ,pay_us_states sta
92: ,pay_us_counties cnt
93: ,pay_us_city_names cty
94: ,pay_us_states sta2
95: ,pay_us_counties cnt2
96: ,pay_us_city_names cty2
97: where adr.person_id = p_person_id
98: and adr.primary_flag = 'Y'
99:

Line 448: pay_us_counties puc,

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
451: and l_effective_date between paf.effective_start_date
452: and paf.effective_end_date

Line 2563: l_res_county_code pay_us_counties.county_code%TYPE;

2559: l_temp_char varchar2(10);
2560: l_assignment_id per_assignments_f.assignment_id%TYPE;
2561: l_person_id per_assignments_f.person_id%TYPE;
2562: l_res_state_code pay_us_states.state_code%TYPE;
2563: l_res_county_code pay_us_counties.county_code%TYPE;
2564: l_res_city_code pay_us_city_names.city_code%TYPE;
2565: l_res_ovrd_state_code pay_us_states.state_code%TYPE;
2566: l_res_ovrd_county_code pay_us_counties.county_code%TYPE;
2567: l_res_ovrd_city_code pay_us_city_names.city_code%TYPE;

Line 2566: l_res_ovrd_county_code pay_us_counties.county_code%TYPE;

2562: l_res_state_code pay_us_states.state_code%TYPE;
2563: l_res_county_code pay_us_counties.county_code%TYPE;
2564: l_res_city_code pay_us_city_names.city_code%TYPE;
2565: l_res_ovrd_state_code pay_us_states.state_code%TYPE;
2566: l_res_ovrd_county_code pay_us_counties.county_code%TYPE;
2567: l_res_ovrd_city_code pay_us_city_names.city_code%TYPE;
2568:
2569: --
2570: cursor csr_per_id is

Line 2840: l_loc_county_code pay_us_counties.county_code%TYPE;

2836: l_defaulting_date per_assignments_f.effective_start_date%TYPE;
2837:
2838: l_loc_state_code pay_us_states.state_code%TYPE;
2839: l_loc_ovrd_state_code pay_us_states.state_code%TYPE;
2840: l_loc_county_code pay_us_counties.county_code%TYPE;
2841: l_loc_ovrd_county_code pay_us_counties.county_code%TYPE;
2842: l_loc_city_code pay_us_city_names.city_code%TYPE;
2843: l_loc_ovrd_city_code pay_us_city_names.city_code%TYPE;
2844:

Line 2841: l_loc_ovrd_county_code pay_us_counties.county_code%TYPE;

2837:
2838: l_loc_state_code pay_us_states.state_code%TYPE;
2839: l_loc_ovrd_state_code pay_us_states.state_code%TYPE;
2840: l_loc_county_code pay_us_counties.county_code%TYPE;
2841: l_loc_ovrd_county_code pay_us_counties.county_code%TYPE;
2842: l_loc_city_code pay_us_city_names.city_code%TYPE;
2843: l_loc_ovrd_city_code pay_us_city_names.city_code%TYPE;
2844:
2845: l_res_state_code pay_us_states.state_code%TYPE;

Line 2846: l_res_county_code pay_us_counties.county_code%TYPE;

2842: l_loc_city_code pay_us_city_names.city_code%TYPE;
2843: l_loc_ovrd_city_code pay_us_city_names.city_code%TYPE;
2844:
2845: l_res_state_code pay_us_states.state_code%TYPE;
2846: l_res_county_code pay_us_counties.county_code%TYPE;
2847: l_res_city_code pay_us_city_names.city_code%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;

Line 2849: l_res_ovrd_county_code pay_us_counties.county_code%TYPE;

2845: l_res_state_code pay_us_states.state_code%TYPE;
2846: l_res_county_code pay_us_counties.county_code%TYPE;
2847: l_res_city_code pay_us_city_names.city_code%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;

Line 2855: l_tax_loc_county_code pay_us_counties.county_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;
2857: l_tax_loc_city_code pay_us_city_names.city_code%TYPE;
2858: l_tax_loc_ovrd_city_code pay_us_city_names.city_code%TYPE;
2859:

Line 2856: l_tax_loc_ovrd_county_code pay_us_counties.county_code%TYPE;

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;
2857: l_tax_loc_city_code pay_us_city_names.city_code%TYPE;
2858: l_tax_loc_ovrd_city_code pay_us_city_names.city_code%TYPE;
2859:
2860: l_sui_state_code pay_us_states.state_code%TYPE;

Line 3318: l_tax_loc_county_code pay_us_counties.county_code%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;
3321: l_tax_loc_ovrd_county_code pay_us_counties.county_code%TYPE;
3322: l_tax_loc_ovrd_city_code pay_us_city_names.city_code%TYPE;

Line 3321: l_tax_loc_ovrd_county_code pay_us_counties.county_code%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;
3321: l_tax_loc_ovrd_county_code pay_us_counties.county_code%TYPE;
3322: l_tax_loc_ovrd_city_code pay_us_city_names.city_code%TYPE;
3323: l_temp_char varchar2(1);
3324: l_temp_num number;
3325: l_cnt number;

Line 3655: l_loc_county_code pay_us_counties.county_code%TYPE;

3651: l_chg_effective_end_date per_assignments_f.effective_end_date%TYPE;
3652: l_sui_state_code pay_us_states.state_code%TYPE;
3653: l_loc_state_code pay_us_states.state_code%TYPE;
3654: l_loc_ovrd_state_code pay_us_states.state_code%TYPE;
3655: l_loc_county_code pay_us_counties.county_code%TYPE;
3656: l_loc_ovrd_county_code pay_us_counties.county_code%TYPE;
3657: l_loc_city_code pay_us_city_names.city_code%TYPE;
3658: l_loc_ovrd_city_code pay_us_city_names.city_name%TYPE;
3659: l_jurisdiction_code pay_us_emp_fed_tax_rules_f.sui_jurisdiction_code%TYPE;

Line 3656: l_loc_ovrd_county_code pay_us_counties.county_code%TYPE;

3652: l_sui_state_code pay_us_states.state_code%TYPE;
3653: l_loc_state_code pay_us_states.state_code%TYPE;
3654: l_loc_ovrd_state_code pay_us_states.state_code%TYPE;
3655: l_loc_county_code pay_us_counties.county_code%TYPE;
3656: l_loc_ovrd_county_code pay_us_counties.county_code%TYPE;
3657: l_loc_city_code pay_us_city_names.city_code%TYPE;
3658: l_loc_ovrd_city_code pay_us_city_names.city_name%TYPE;
3659: l_jurisdiction_code pay_us_emp_fed_tax_rules_f.sui_jurisdiction_code%TYPE;
3660: l_csr_state_code pay_us_states.state_code%TYPE;

Line 3661: l_csr_county_code pay_us_counties.county_code%TYPE;

3657: l_loc_city_code pay_us_city_names.city_code%TYPE;
3658: l_loc_ovrd_city_code pay_us_city_names.city_name%TYPE;
3659: l_jurisdiction_code pay_us_emp_fed_tax_rules_f.sui_jurisdiction_code%TYPE;
3660: l_csr_state_code pay_us_states.state_code%TYPE;
3661: l_csr_county_code pay_us_counties.county_code%TYPE;
3662: l_csr_city_code pay_us_city_names.city_code%TYPE;
3663:
3664: l_dt_mode varchar2(25);
3665: l_pct_eff_start_date pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;

Line 5236: l_loc_county_code pay_us_counties.county_code%TYPE;

5232: l_defaulting_met boolean;
5233: l_asg_eed per_assignments_f.effective_end_date%TYPE;
5234: l_asg_esd per_assignments_f.effective_start_date%TYPE;
5235: l_loc_state_code pay_us_states.state_code%TYPE;
5236: l_loc_county_code pay_us_counties.county_code%TYPE;
5237: l_loc_city_code pay_us_city_names.city_code%TYPE;
5238: l_loc_ovrd_state_code pay_us_states.state_code%TYPE;
5239: l_loc_ovrd_county_code pay_us_counties.county_code%TYPE;
5240: l_loc_ovrd_city_code pay_us_city_names.city_code%TYPE;

Line 5239: l_loc_ovrd_county_code pay_us_counties.county_code%TYPE;

5235: l_loc_state_code pay_us_states.state_code%TYPE;
5236: l_loc_county_code pay_us_counties.county_code%TYPE;
5237: l_loc_city_code pay_us_city_names.city_code%TYPE;
5238: l_loc_ovrd_state_code pay_us_states.state_code%TYPE;
5239: l_loc_ovrd_county_code pay_us_counties.county_code%TYPE;
5240: l_loc_ovrd_city_code pay_us_city_names.city_code%TYPE;
5241: l_state_code pay_us_emp_state_tax_rules_f.state_code%TYPE;
5242: l_county_code pay_us_emp_county_tax_rules_f.county_code%TYPE;
5243: l_city_code pay_us_emp_city_tax_rules_f.city_code%TYPE;