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_STATES

Line 36: ,pay_us_states sta

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

Line 39: ,pay_us_states sta2

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
42: where loc.location_id = p_lc_id
43: AND cnt.state_code = sta.state_code

Line 61: ,pay_us_states sta

57: cursor csr_res_addr(p_person_id number,p_effective_date date) is
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

Line 64: ,pay_us_states sta2

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
67: where adr.person_id = p_person_id
68: and adr.primary_flag = 'Y'

Line 91: ,pay_us_states sta

87: cursor csr_res_addr_no_eff_dt(p_person_id number,p_effective_date date) is
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

Line 94: ,pay_us_states sta2

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
97: where adr.person_id = p_person_id
98: and adr.primary_flag = 'Y'

Line 449: pay_us_states pus,

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
453: and l_effective_date between paf.effective_start_date

Line 2564: l_res_state_code pay_us_states.state_code%TYPE;

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

Line 2567: l_res_ovrd_state_code pay_us_states.state_code%TYPE;

2563: l_person_id per_assignments_f.person_id%TYPE;
2564: l_res_state_code pay_us_states.state_code%TYPE;
2565: l_res_county_code pay_us_counties.county_code%TYPE;
2566: l_res_city_code pay_us_city_names.city_code%TYPE;
2567: l_res_ovrd_state_code pay_us_states.state_code%TYPE;
2568: l_res_ovrd_county_code pay_us_counties.county_code%TYPE;
2569: l_res_ovrd_city_code pay_us_city_names.city_code%TYPE;
2570:
2571: --

Line 2840: l_loc_state_code pay_us_states.state_code%TYPE;

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

Line 2841: l_loc_ovrd_state_code pay_us_states.state_code%TYPE;

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

Line 2847: l_res_state_code pay_us_states.state_code%TYPE;

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

Line 2850: l_res_ovrd_state_code pay_us_states.state_code%TYPE;

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

Line 2855: l_tax_loc_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;
2859: l_tax_loc_city_code pay_us_city_names.city_code%TYPE;

Line 2856: l_tax_loc_ovrd_state_code pay_us_states.state_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;
2859: l_tax_loc_city_code pay_us_city_names.city_code%TYPE;
2860: l_tax_loc_ovrd_city_code pay_us_city_names.city_code%TYPE;

Line 2862: l_sui_state_code pay_us_states.state_code%TYPE;

2858: l_tax_loc_ovrd_county_code pay_us_counties.county_code%TYPE;
2859: l_tax_loc_city_code pay_us_city_names.city_code%TYPE;
2860: l_tax_loc_ovrd_city_code pay_us_city_names.city_code%TYPE;
2861:
2862: l_sui_state_code pay_us_states.state_code%TYPE;
2863: l_sui_state_jd_code pay_state_rules.jurisdiction_code%TYPE;
2864:
2865: l_tmp_loc_id number;
2866: l_hold_loc_id number;

Line 3319: l_tax_loc_state_code pay_us_states.state_code%TYPE;

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;
3323: l_tax_loc_ovrd_county_code pay_us_counties.county_code%TYPE;

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

Line 3736: l_sui_state_code pay_us_states.state_code%TYPE;

3732: l_location_id per_assignments_f.location_id%TYPE;
3733: l_loc_id per_assignments_f.location_id%TYPE;
3734: l_chg_effective_start_date per_assignments_f.effective_start_date%TYPE;
3735: l_chg_effective_end_date per_assignments_f.effective_end_date%TYPE;
3736: l_sui_state_code pay_us_states.state_code%TYPE;
3737: l_loc_state_code pay_us_states.state_code%TYPE;
3738: l_loc_ovrd_state_code pay_us_states.state_code%TYPE;
3739: l_loc_county_code pay_us_counties.county_code%TYPE;
3740: l_loc_ovrd_county_code pay_us_counties.county_code%TYPE;

Line 3737: l_loc_state_code pay_us_states.state_code%TYPE;

3733: l_loc_id per_assignments_f.location_id%TYPE;
3734: l_chg_effective_start_date per_assignments_f.effective_start_date%TYPE;
3735: l_chg_effective_end_date per_assignments_f.effective_end_date%TYPE;
3736: l_sui_state_code pay_us_states.state_code%TYPE;
3737: l_loc_state_code pay_us_states.state_code%TYPE;
3738: l_loc_ovrd_state_code pay_us_states.state_code%TYPE;
3739: l_loc_county_code pay_us_counties.county_code%TYPE;
3740: l_loc_ovrd_county_code pay_us_counties.county_code%TYPE;
3741: l_loc_city_code pay_us_city_names.city_code%TYPE;

Line 3738: l_loc_ovrd_state_code pay_us_states.state_code%TYPE;

3734: l_chg_effective_start_date per_assignments_f.effective_start_date%TYPE;
3735: l_chg_effective_end_date per_assignments_f.effective_end_date%TYPE;
3736: l_sui_state_code pay_us_states.state_code%TYPE;
3737: l_loc_state_code pay_us_states.state_code%TYPE;
3738: l_loc_ovrd_state_code pay_us_states.state_code%TYPE;
3739: l_loc_county_code pay_us_counties.county_code%TYPE;
3740: l_loc_ovrd_county_code pay_us_counties.county_code%TYPE;
3741: l_loc_city_code pay_us_city_names.city_code%TYPE;
3742: l_loc_ovrd_city_code pay_us_city_names.city_name%TYPE;

Line 3744: l_csr_state_code pay_us_states.state_code%TYPE;

3740: l_loc_ovrd_county_code pay_us_counties.county_code%TYPE;
3741: l_loc_city_code pay_us_city_names.city_code%TYPE;
3742: l_loc_ovrd_city_code pay_us_city_names.city_name%TYPE;
3743: l_jurisdiction_code pay_us_emp_fed_tax_rules_f.sui_jurisdiction_code%TYPE;
3744: l_csr_state_code pay_us_states.state_code%TYPE;
3745: l_csr_county_code pay_us_counties.county_code%TYPE;
3746: l_csr_city_code pay_us_city_names.city_code%TYPE;
3747:
3748: l_dt_mode varchar2(25);

Line 5319: l_loc_state_code pay_us_states.state_code%TYPE;

5315: l_default_flag varchar2(1) := 'Y';
5316: l_defaulting_met boolean;
5317: l_asg_eed per_assignments_f.effective_end_date%TYPE;
5318: l_asg_esd per_assignments_f.effective_start_date%TYPE;
5319: l_loc_state_code pay_us_states.state_code%TYPE;
5320: l_loc_county_code pay_us_counties.county_code%TYPE;
5321: l_loc_city_code pay_us_city_names.city_code%TYPE;
5322: l_loc_ovrd_state_code pay_us_states.state_code%TYPE;
5323: l_loc_ovrd_county_code pay_us_counties.county_code%TYPE;

Line 5322: l_loc_ovrd_state_code pay_us_states.state_code%TYPE;

5318: l_asg_esd per_assignments_f.effective_start_date%TYPE;
5319: l_loc_state_code pay_us_states.state_code%TYPE;
5320: l_loc_county_code pay_us_counties.county_code%TYPE;
5321: l_loc_city_code pay_us_city_names.city_code%TYPE;
5322: l_loc_ovrd_state_code pay_us_states.state_code%TYPE;
5323: l_loc_ovrd_county_code pay_us_counties.county_code%TYPE;
5324: l_loc_ovrd_city_code pay_us_city_names.city_code%TYPE;
5325: l_state_code pay_us_emp_state_tax_rules_f.state_code%TYPE;
5326: l_county_code pay_us_emp_county_tax_rules_f.county_code%TYPE;