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_EMP_COUNTY_TAX_RULES_F

Line 128: from pay_us_emp_county_tax_rules_f cnt

124: cursor csr_future_county_rule( p_state_code number, p_county_code number,
125: p_assignment_id number,
126: l_csr_date date default hr_api.g_sot) is
127: select null
128: from pay_us_emp_county_tax_rules_f cnt
129: where cnt.assignment_id = p_assignment_id
130: and cnt.state_code = p_state_code
131: and cnt.county_code = p_county_code
132: and cnt.effective_start_date > l_csr_date;

Line 4066: from pay_us_emp_county_tax_rules_f

4062: ,cnt_information27
4063: ,cnt_information28
4064: ,cnt_information29
4065: ,cnt_information30
4066: from pay_us_emp_county_tax_rules_f
4067: where assignment_id = l_csr_assignment_id
4068: and effective_end_date >= l_csr_start_date
4069: and effective_start_date <= l_csr_end_date;
4070: --

Line 4169: from pay_us_emp_county_tax_rules_f cnt

4165: where sta.assignment_id = p_assignment_id;
4166: --
4167: cursor csr_asg_county_code is
4168: select cnt.state_code, cnt.county_code
4169: from pay_us_emp_county_tax_rules_f cnt
4170: where cnt.assignment_id = p_assignment_id;
4171: --
4172: cursor csr_asg_city_code is
4173: select cty.state_code, cty.county_code, cty.city_code

Line 5242: l_county_code pay_us_emp_county_tax_rules_f.county_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;
5244: l_city_pct number;
5245: --
5246: l_fed_rec pay_fed_shd.g_rec_type;

Line 5676: from pay_us_emp_county_tax_rules_f

5672: ,cnt_information27
5673: ,cnt_information28
5674: ,cnt_information29
5675: ,cnt_information30
5676: from pay_us_emp_county_tax_rules_f
5677: where assignment_id = l_csr_assignment_id
5678: and l_csr_effective_date between effective_start_date
5679: and effective_end_date;
5680: --

Line 5825: update pay_us_emp_county_tax_rules_f

5821: --
5822: for l_county_rec in csr_county_rec(p_assignment_id, p_defaulting_date)
5823: loop
5824: --
5825: update pay_us_emp_county_tax_rules_f
5826: set effective_start_date = p_new_default_date
5827: where effective_start_date = p_defaulting_date
5828: and assignment_id = p_assignment_id
5829: and state_code = l_county_rec.state_code

Line 6196: delete from pay_us_emp_county_tax_rules_f

6192: );
6193: --
6194: end loop; -- l_county_rec
6195: --
6196: delete from pay_us_emp_county_tax_rules_f
6197: where assignment_id = p_assignment_id
6198: and effective_start_date < p_new_default_date;
6199: --
6200: for l_city_rec in csr_city_rec(p_assignment_id, p_new_default_date)

Line 6644: update pay_us_emp_county_tax_rules_f

6640: --
6641: for l_county_rec in csr_county_rec(p_assignment_id, l_defaulting_date)
6642: loop
6643: --
6644: update pay_us_emp_county_tax_rules_f
6645: set effective_start_date = l_new_default_date
6646: where effective_start_date = l_defaulting_date
6647: and assignment_id = p_assignment_id
6648: and state_code = l_county_rec.state_code

Line 7005: update pay_us_emp_county_tax_rules_f

7001: --
7002: for l_county_rec in csr_county_rec(p_assignment_id, l_defaulting_date)
7003: loop
7004: --
7005: update pay_us_emp_county_tax_rules_f
7006: set effective_start_date = l_new_default_date
7007: where effective_start_date = l_defaulting_date
7008: and assignment_id = p_assignment_id
7009: and state_code = l_county_rec.state_code