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_COUNTY_TAX_RULES

Line 321: DELETE FROM hr_h2pi_county_tax_rules

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
322: WHERE client_id = p_from_client_id
323: AND status = 'C';
324:
325: DELETE FROM hr_h2pi_city_tax_rules

Line 441: FROM hr_h2pi_county_tax_rules

437: WHERE (status IS NULL OR status <> 'C')
438: AND client_id = p_bg_id
439: UNION
440: SELECT DISTINCT person_id
441: FROM hr_h2pi_county_tax_rules
442: WHERE (status IS NULL OR status <> 'C')
443: AND client_id = p_bg_id
444: UNION
445: SELECT DISTINCT person_id

Line 570: FROM HR_H2PI_COUNTY_TAX_RULES

566: effective_start_date eff_date,
567: 12 ord,
568: 'upload_county_tax_record' fn_name,
569: DECODE(last_upd_date, g_eot, 1, 2) sub_order
570: FROM HR_H2PI_COUNTY_TAX_RULES
571: WHERE (status IS NULL OR status <> 'C')
572: AND person_id = p_per_id
573: AND client_id = p_from_client_id
574: UNION

Line 1632: FROM hr_h2pi_county_tax_rules_v

1628: CURSOR csr_county_tax_rule (p_asg_id NUMBER,
1629: p_date DATE) IS
1630: SELECT emp_county_tax_rule_id,
1631: jurisdiction_code
1632: FROM hr_h2pi_county_tax_rules_v
1633: WHERE assignment_id = p_asg_id
1634: AND p_date BETWEEN effective_start_date
1635: AND effective_end_date;
1636:

Line 1704: l_ud_emp_county_tax_rule_id hr_h2pi_county_tax_rules.emp_county_tax_rule_id%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;
1708: l_emp_county_tax_rule_id hr_h2pi_county_tax_rules.emp_county_tax_rule_id%TYPE;

Line 1708: l_emp_county_tax_rule_id hr_h2pi_county_tax_rules.emp_county_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;
1712: l_future_term_flag BOOLEAN := FALSE;

Line 2330: FROM hr_h2pi_county_tax_rules

2326: IF l_temp_id = -1 THEN
2327:
2328: SELECT emp_county_tax_rule_id
2329: INTO l_ud_emp_county_tax_rule_id
2330: FROM hr_h2pi_county_tax_rules
2331: WHERE assignment_id = v_ud_asg.assignment_id
2332: AND client_id = p_from_client_id
2333: AND jurisdiction_code = v_cnt.jurisdiction_code
2334: AND v_ud_asg.effective_start_date BETWEEN effective_start_date

Line 4445: FROM hr_h2pi_county_tax_rules cnt

4441:
4442: CURSOR csr_ud_county_tax_rule (p_cnt_id NUMBER,
4443: p_esd DATE) IS
4444: SELECT *
4445: FROM hr_h2pi_county_tax_rules cnt
4446: WHERE cnt.emp_county_tax_rule_id = p_cnt_id
4447: AND cnt.client_id = p_from_client_id
4448: AND cnt.effective_start_date = p_esd;
4449:

Line 4453: FROM hr_h2pi_county_tax_rules_v cnt

4449:
4450: CURSOR csr_ed_county_tax_rule (p_cnt_id NUMBER,
4451: p_esd DATE) IS
4452: SELECT *
4453: FROM hr_h2pi_county_tax_rules_v cnt
4454: WHERE cnt.emp_county_tax_rule_id = p_cnt_id
4455: AND p_esd BETWEEN cnt.effective_start_date
4456: AND cnt.effective_end_date;
4457:

Line 4470: v_ud_cnt hr_h2pi_county_tax_rules%ROWTYPE;

4466: l_encoded_message VARCHAR2(200);
4467:
4468: l_proc VARCHAR2(72) := g_package||'upload_county_tax_rule';
4469:
4470: v_ud_cnt hr_h2pi_county_tax_rules%ROWTYPE;
4471: v_ed_cnt hr_h2pi_county_tax_rules_v%ROWTYPE;
4472:
4473: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
4474: l_emp_county_tax_rule_id

Line 4471: v_ed_cnt hr_h2pi_county_tax_rules_v%ROWTYPE;

4467:
4468: l_proc VARCHAR2(72) := g_package||'upload_county_tax_rule';
4469:
4470: v_ud_cnt hr_h2pi_county_tax_rules%ROWTYPE;
4471: v_ed_cnt hr_h2pi_county_tax_rules_v%ROWTYPE;
4472:
4473: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
4474: l_emp_county_tax_rule_id
4475: pay_us_emp_county_tax_rules_f.emp_county_tax_rule_id%TYPE;

Line 4553: p_table_name => 'HR_H2PI_COUNTY_TAX_RULES',

4549: ROLLBACK;
4550: hr_utility.set_location(l_proc, 70);
4551: hr_h2pi_error.data_error
4552: (p_from_id => l_emp_county_tax_rule_id,
4553: p_table_name => 'HR_H2PI_COUNTY_TAX_RULES',
4554: p_message_level => 'FATAL',
4555: p_message_name => 'HR_289240_MAPPING_ID_INVALID');
4556: COMMIT;
4557: RAISE MAPPING_ID_INVALID;

Line 4666: UPDATE hr_h2pi_county_tax_rules cnt

4662: );
4663: END IF;
4664:
4665: hr_utility.set_location(l_proc, 150);
4666: UPDATE hr_h2pi_county_tax_rules cnt
4667: SET status = 'C'
4668: WHERE cnt.emp_county_tax_rule_id = v_ud_cnt.emp_county_tax_rule_id
4669: AND cnt.client_id = p_from_client_id
4670: AND cnt.effective_start_date = v_ud_cnt.effective_start_date

Line 4684: p_table_name => 'HR_H2PI_COUNTY_TAX_RULES',

4680: hr_utility.set_location(l_proc, 170);
4681: l_encoded_message := fnd_message.get_encoded;
4682: hr_h2pi_error.data_error
4683: (p_from_id => v_ud_cnt.emp_county_tax_rule_id,
4684: p_table_name => 'HR_H2PI_COUNTY_TAX_RULES',
4685: p_message_level => 'FATAL',
4686: p_message_text => l_encoded_message);
4687: COMMIT;
4688: RAISE;