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_CITY_TAX_RULES

Line 325: DELETE FROM hr_h2pi_city_tax_rules

321: DELETE FROM hr_h2pi_county_tax_rules
322: WHERE client_id = p_from_client_id
323: AND status = 'C';
324:
325: DELETE FROM hr_h2pi_city_tax_rules
326: WHERE client_id = p_from_client_id
327: AND status = 'C';
328:
329: DELETE FROM hr_h2pi_salaries

Line 446: FROM hr_h2pi_city_tax_rules

442: WHERE (status IS NULL OR status <> 'C')
443: AND client_id = p_bg_id
444: UNION
445: SELECT DISTINCT person_id
446: FROM hr_h2pi_city_tax_rules
447: WHERE (status IS NULL OR status <> 'C')
448: AND client_id = p_bg_id
449: ORDER BY person_id;
450:

Line 580: FROM HR_H2PI_CITY_TAX_RULES

576: effective_start_date eff_date,
577: 13 ord,
578: 'upload_city_tax_record' fn_name,
579: DECODE(last_upd_date, g_eot, 1, 2) sub_order
580: FROM HR_H2PI_CITY_TAX_RULES
581: WHERE (status IS NULL OR status <> 'C')
582: AND person_id = p_per_id
583: AND client_id = p_from_client_id
584: ORDER BY eff_date,

Line 1641: FROM hr_h2pi_city_tax_rules_v

1637: CURSOR csr_city_tax_rule (p_asg_id NUMBER,
1638: p_date DATE) IS
1639: SELECT emp_city_tax_rule_id,
1640: jurisdiction_code
1641: FROM hr_h2pi_city_tax_rules_v
1642: WHERE assignment_id = p_asg_id
1643: AND p_date BETWEEN effective_start_date
1644: AND effective_end_date;
1645:

Line 1705: l_ud_emp_city_tax_rule_id hr_h2pi_city_tax_rules.emp_city_tax_rule_id%TYPE;

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;
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;

Line 1709: l_emp_city_tax_rule_id hr_h2pi_city_tax_rules.emp_city_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;
1712: l_future_term_flag BOOLEAN := FALSE;
1713:

Line 2355: FROM hr_h2pi_city_tax_rules

2351: IF l_temp_id = -1 THEN
2352:
2353: SELECT emp_city_tax_rule_id
2354: INTO l_ud_emp_city_tax_rule_id
2355: FROM hr_h2pi_city_tax_rules
2356: WHERE assignment_id = v_ud_asg.assignment_id
2357: AND client_id = p_from_client_id
2358: AND jurisdiction_code = v_cty.jurisdiction_code
2359: AND v_ud_asg.effective_start_date BETWEEN effective_start_date

Line 4700: FROM hr_h2pi_city_tax_rules cty

4696:
4697: CURSOR csr_ud_city_tax_rule (p_cty_id NUMBER,
4698: p_esd DATE) IS
4699: SELECT *
4700: FROM hr_h2pi_city_tax_rules cty
4701: WHERE cty.emp_city_tax_rule_id = p_cty_id
4702: AND cty.client_Id = p_from_client_id
4703: AND cty.effective_start_date = p_esd;
4704:

Line 4708: FROM hr_h2pi_city_tax_rules_v cty

4704:
4705: CURSOR csr_ed_city_tax_rule (p_cty_id NUMBER,
4706: p_esd DATE) IS
4707: SELECT *
4708: FROM hr_h2pi_city_tax_rules_v cty
4709: WHERE cty.emp_city_tax_rule_id = p_cty_id
4710: AND p_esd BETWEEN cty.effective_start_date
4711: AND cty.effective_end_date;
4712:

Line 4725: v_ud_cty hr_h2pi_city_tax_rules%ROWTYPE;

4721: l_encoded_message VARCHAR2(200);
4722:
4723: l_proc VARCHAR2(72) := g_package||'upload_city_tax_rule';
4724:
4725: v_ud_cty hr_h2pi_city_tax_rules%ROWTYPE;
4726: v_ed_cty hr_h2pi_city_tax_rules_v%ROWTYPE;
4727:
4728: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
4729: l_emp_city_tax_rule_id

Line 4726: v_ed_cty hr_h2pi_city_tax_rules_v%ROWTYPE;

4722:
4723: l_proc VARCHAR2(72) := g_package||'upload_city_tax_rule';
4724:
4725: v_ud_cty hr_h2pi_city_tax_rules%ROWTYPE;
4726: v_ed_cty hr_h2pi_city_tax_rules_v%ROWTYPE;
4727:
4728: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
4729: l_emp_city_tax_rule_id
4730: pay_us_emp_city_tax_rules_f.emp_city_tax_rule_id%TYPE;

Line 4809: p_table_name => 'HR_H2PI_CITY_TAX_RULES',

4805: ROLLBACK;
4806: hr_utility.set_location(l_proc, 70);
4807: hr_h2pi_error.data_error
4808: (p_from_id => l_emp_city_tax_rule_id,
4809: p_table_name => 'HR_H2PI_CITY_TAX_RULES',
4810: p_message_level => 'FATAL',
4811: p_message_name => 'HR_289240_MAPPING_ID_INVALID');
4812: COMMIT;
4813: RAISE MAPPING_ID_INVALID;

Line 4920: UPDATE hr_h2pi_city_tax_rules sta

4916: );
4917: END IF;
4918:
4919: hr_utility.set_location(l_proc, 150);
4920: UPDATE hr_h2pi_city_tax_rules sta
4921: SET status = 'C'
4922: WHERE sta.emp_city_tax_rule_id = v_ud_cty.emp_city_tax_rule_id
4923: AND sta.client_id = p_from_client_id
4924: AND sta.effective_start_date = v_ud_cty.effective_start_date

Line 4938: p_table_name => 'HR_H2PI_CITY_TAX_RULES',

4934: hr_utility.set_location(l_proc, 170);
4935: l_encoded_message := fnd_message.get_encoded;
4936: hr_h2pi_error.data_error
4937: (p_from_id => v_ud_cty.emp_city_tax_rule_id,
4938: p_table_name => 'HR_H2PI_CITY_TAX_RULES',
4939: p_message_level => 'FATAL',
4940: p_message_text => l_encoded_message);
4941: COMMIT;
4942: RAISE;