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.HR_H2PI_PERSON_UPLOAD dependencies on HR_H2PI_STATE_TAX_RULES

Line 317: DELETE FROM hr_h2pi_state_tax_rules

313: DELETE FROM hr_h2pi_federal_tax_rules
314: WHERE client_id = p_from_client_id
315: AND status = 'C';
316:
317: DELETE FROM hr_h2pi_state_tax_rules
318: WHERE client_id = p_from_client_id
319: AND status = 'C';
320:
321: DELETE FROM hr_h2pi_county_tax_rules

Line 436: FROM hr_h2pi_state_tax_rules

432: WHERE (status IS NULL OR status <> 'C')
433: AND client_id = p_bg_id
434: UNION
435: SELECT DISTINCT person_id
436: FROM hr_h2pi_state_tax_rules
437: WHERE (status IS NULL OR status <> 'C')
438: AND client_id = p_bg_id
439: UNION
440: SELECT DISTINCT person_id

Line 560: FROM HR_H2PI_STATE_TAX_RULES

556: effective_start_date eff_date,
557: 11 ord,
558: 'upload_state_tax_record' fn_name,
559: DECODE(last_upd_date, g_eot, 1, 2) sub_order
560: FROM HR_H2PI_STATE_TAX_RULES
561: WHERE (status IS NULL OR status <> 'C')
562: AND person_id = p_per_id
563: AND client_id = p_from_client_id
564: UNION

Line 1623: FROM hr_h2pi_state_tax_rules_v

1619: CURSOR csr_state_tax_rule (p_asg_id NUMBER,
1620: p_date DATE) IS
1621: SELECT emp_state_tax_rule_id,
1622: jurisdiction_code
1623: FROM hr_h2pi_state_tax_rules_v
1624: WHERE assignment_id = p_asg_id
1625: AND p_date BETWEEN effective_start_date
1626: AND effective_end_date;
1627:

Line 1703: l_ud_emp_state_tax_rule_id hr_h2pi_state_tax_rules.emp_state_tax_rule_id%TYPE;

1699: l_final_process_date per_periods_of_service.final_process_date%TYPE;
1700:
1701: l_temp_id NUMBER(15);
1702: l_ud_emp_fed_tax_rule_id hr_h2pi_federal_tax_rules.emp_fed_tax_rule_id%TYPE;
1703: l_ud_emp_state_tax_rule_id hr_h2pi_state_tax_rules.emp_state_tax_rule_id%TYPE;
1704: l_ud_emp_county_tax_rule_id hr_h2pi_county_tax_rules.emp_county_tax_rule_id%TYPE;
1705: l_ud_emp_city_tax_rule_id hr_h2pi_city_tax_rules.emp_city_tax_rule_id%TYPE;
1706: l_emp_fed_tax_rule_id hr_h2pi_federal_tax_rules.emp_fed_tax_rule_id%TYPE;
1707: l_emp_state_tax_rule_id hr_h2pi_state_tax_rules.emp_state_tax_rule_id%TYPE;

Line 1707: l_emp_state_tax_rule_id hr_h2pi_state_tax_rules.emp_state_tax_rule_id%TYPE;

1703: l_ud_emp_state_tax_rule_id hr_h2pi_state_tax_rules.emp_state_tax_rule_id%TYPE;
1704: l_ud_emp_county_tax_rule_id hr_h2pi_county_tax_rules.emp_county_tax_rule_id%TYPE;
1705: l_ud_emp_city_tax_rule_id hr_h2pi_city_tax_rules.emp_city_tax_rule_id%TYPE;
1706: l_emp_fed_tax_rule_id hr_h2pi_federal_tax_rules.emp_fed_tax_rule_id%TYPE;
1707: l_emp_state_tax_rule_id hr_h2pi_state_tax_rules.emp_state_tax_rule_id%TYPE;
1708: l_emp_county_tax_rule_id hr_h2pi_county_tax_rules.emp_county_tax_rule_id%TYPE;
1709: l_emp_city_tax_rule_id hr_h2pi_city_tax_rules.emp_city_tax_rule_id%TYPE;
1710:
1711: l_dummy_person_type hr_h2pi_employees_v.person_type%TYPE;

Line 2305: FROM hr_h2pi_state_tax_rules

2301: IF l_temp_id = -1 THEN
2302:
2303: SELECT emp_state_tax_rule_id
2304: INTO l_ud_emp_state_tax_rule_id
2305: FROM hr_h2pi_state_tax_rules
2306: WHERE assignment_id = v_ud_asg.assignment_id
2307: AND client_id = p_from_client_id
2308: AND jurisdiction_code = v_sta.jurisdiction_code
2309: AND v_ud_asg.effective_start_date BETWEEN effective_start_date

Line 4164: FROM hr_h2pi_state_tax_rules sta

4160:
4161: CURSOR csr_ud_state_tax_rule (p_sta_id NUMBER,
4162: p_esd DATE) IS
4163: SELECT *
4164: FROM hr_h2pi_state_tax_rules sta
4165: WHERE sta.emp_state_tax_rule_id = p_sta_id
4166: AND sta.client_id = p_from_client_id
4167: AND sta.effective_start_date = p_esd;
4168:

Line 4172: FROM hr_h2pi_state_tax_rules_v sta

4168:
4169: CURSOR csr_ed_state_tax_rule (p_sta_id NUMBER,
4170: p_esd DATE) IS
4171: SELECT *
4172: FROM hr_h2pi_state_tax_rules_v sta
4173: WHERE sta.emp_state_tax_rule_id = p_sta_id
4174: AND p_esd BETWEEN sta.effective_start_date
4175: AND sta.effective_end_date;
4176:

Line 4189: v_ud_sta hr_h2pi_state_tax_rules%ROWTYPE;

4185: l_encoded_message VARCHAR2(200);
4186:
4187: l_proc VARCHAR2(72) := g_package||'upload_state_tax_rule';
4188:
4189: v_ud_sta hr_h2pi_state_tax_rules%ROWTYPE;
4190: v_ed_sta hr_h2pi_state_tax_rules_v%ROWTYPE;
4191:
4192: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
4193: l_emp_state_tax_rule_id

Line 4190: v_ed_sta hr_h2pi_state_tax_rules_v%ROWTYPE;

4186:
4187: l_proc VARCHAR2(72) := g_package||'upload_state_tax_rule';
4188:
4189: v_ud_sta hr_h2pi_state_tax_rules%ROWTYPE;
4190: v_ed_sta hr_h2pi_state_tax_rules_v%ROWTYPE;
4191:
4192: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
4193: l_emp_state_tax_rule_id
4194: pay_us_emp_state_tax_rules_f.emp_state_tax_rule_id%TYPE;

Line 4280: p_table_name => 'HR_H2PI_STATE_TAX_RULES',

4276: ROLLBACK;
4277: hr_utility.set_location(l_proc, 70);
4278: hr_h2pi_error.data_error
4279: (p_from_id => l_emp_state_tax_rule_id,
4280: p_table_name => 'HR_H2PI_STATE_TAX_RULES',
4281: p_message_level => 'FATAL',
4282: p_message_name => 'HR_289240_MAPPING_ID_INVALID');
4283: COMMIT;
4284: RAISE MAPPING_ID_INVALID;

Line 4410: UPDATE hr_h2pi_state_tax_rules sta

4406:
4407: END IF;
4408:
4409: hr_utility.set_location(l_proc, 150);
4410: UPDATE hr_h2pi_state_tax_rules sta
4411: SET status = 'C'
4412: WHERE sta.emp_state_tax_rule_id = v_ud_sta.emp_state_tax_rule_id
4413: AND sta.client_id = p_from_client_id
4414: AND sta.effective_start_date = v_ud_sta.effective_start_date

Line 4428: p_table_name => 'HR_H2PI_STATE_TAX_RULES',

4424: hr_utility.set_location(l_proc, 170);
4425: l_encoded_message := fnd_message.get_encoded;
4426: hr_h2pi_error.data_error
4427: (p_from_id => v_ud_sta.emp_state_tax_rule_id,
4428: p_table_name => 'HR_H2PI_STATE_TAX_RULES',
4429: p_message_level => 'FATAL',
4430: p_message_text => l_encoded_message);
4431: COMMIT;
4432: RAISE;

Line 5133: FROM hr_h2pi_state_tax_rules_v

5129:
5130: CURSOR csr_element_entry (p_asg_id NUMBER) IS
5131: SELECT emp_state_tax_rule_id,
5132: jurisdiction_code
5133: FROM hr_h2pi_state_tax_rules_v
5134: WHERE assignment_id = p_asg_id;
5135:
5136: l_proc VARCHAR2(72) := g_package||'upload_tax_percentage';
5137: