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 4150: from pay_us_emp_county_tax_rules_f

4146: ,cnt_information27
4147: ,cnt_information28
4148: ,cnt_information29
4149: ,cnt_information30
4150: from pay_us_emp_county_tax_rules_f
4151: where assignment_id = l_csr_assignment_id
4152: and effective_end_date >= l_csr_start_date
4153: and effective_start_date <= l_csr_end_date;
4154: --

Line 4253: from pay_us_emp_county_tax_rules_f cnt

4249: where sta.assignment_id = p_assignment_id;
4250: --
4251: cursor csr_asg_county_code is
4252: select cnt.state_code, cnt.county_code
4253: from pay_us_emp_county_tax_rules_f cnt
4254: where cnt.assignment_id = p_assignment_id;
4255: --
4256: cursor csr_asg_city_code is
4257: select cty.state_code, cty.county_code, cty.city_code

Line 5326: l_county_code pay_us_emp_county_tax_rules_f.county_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;
5327: l_city_code pay_us_emp_city_tax_rules_f.city_code%TYPE;
5328: l_city_pct number;
5329: --
5330: l_fed_rec pay_fed_shd.g_rec_type;

Line 5760: from pay_us_emp_county_tax_rules_f

5756: ,cnt_information27
5757: ,cnt_information28
5758: ,cnt_information29
5759: ,cnt_information30
5760: from pay_us_emp_county_tax_rules_f
5761: where assignment_id = l_csr_assignment_id
5762: and l_csr_effective_date between effective_start_date
5763: and effective_end_date;
5764: --

Line 5909: update pay_us_emp_county_tax_rules_f

5905: --
5906: for l_county_rec in csr_county_rec(p_assignment_id, p_defaulting_date)
5907: loop
5908: --
5909: update pay_us_emp_county_tax_rules_f
5910: set effective_start_date = p_new_default_date
5911: where effective_start_date = p_defaulting_date
5912: and assignment_id = p_assignment_id
5913: and state_code = l_county_rec.state_code

Line 6280: delete from pay_us_emp_county_tax_rules_f

6276: );
6277: --
6278: end loop; -- l_county_rec
6279: --
6280: delete from pay_us_emp_county_tax_rules_f
6281: where assignment_id = p_assignment_id
6282: and effective_start_date < p_new_default_date;
6283: --
6284: for l_city_rec in csr_city_rec(p_assignment_id, p_new_default_date)

Line 6728: update pay_us_emp_county_tax_rules_f

6724: --
6725: for l_county_rec in csr_county_rec(p_assignment_id, l_defaulting_date)
6726: loop
6727: --
6728: update pay_us_emp_county_tax_rules_f
6729: set effective_start_date = l_new_default_date
6730: where effective_start_date = l_defaulting_date
6731: and assignment_id = p_assignment_id
6732: and state_code = l_county_rec.state_code

Line 7089: update pay_us_emp_county_tax_rules_f

7085: --
7086: for l_county_rec in csr_county_rec(p_assignment_id, l_defaulting_date)
7087: loop
7088: --
7089: update pay_us_emp_county_tax_rules_f
7090: set effective_start_date = l_new_default_date
7091: where effective_start_date = l_defaulting_date
7092: and assignment_id = p_assignment_id
7093: and state_code = l_county_rec.state_code