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.

[Home] [Help]

APPS.HR_H2PI_PERSON_UPLOAD dependencies on HR_H2PI_FEDERAL_TAX_RULES

Line 313: DELETE FROM hr_h2pi_federal_tax_rules

309: DELETE FROM hr_h2pi_org_payment_methods
310: WHERE client_id = p_from_client_id
311: AND status = 'C';
312:
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

Line 431: FROM hr_h2pi_federal_tax_rules

427: WHERE (status IS NULL OR status <> 'C')
428: AND client_id = p_bg_id
429: UNION
430: SELECT DISTINCT person_id
431: FROM hr_h2pi_federal_tax_rules
432: WHERE (status IS NULL OR status <> 'C')
433: AND client_id = p_bg_id
434: UNION
435: SELECT DISTINCT person_id

Line 550: FROM HR_H2PI_FEDERAL_TAX_RULES

546: effective_start_date eff_date,
547: 10 ord,
548: 'upload_federal_tax_record' fn_name,
549: DECODE(last_upd_date, g_eot, 1, 2) sub_order
550: FROM HR_H2PI_FEDERAL_TAX_RULES
551: WHERE (status IS NULL OR status <> 'C')
552: AND person_id = p_per_id
553: AND client_id = p_from_client_id
554: UNION

Line 1702: l_ud_emp_fed_tax_rule_id hr_h2pi_federal_tax_rules.emp_fed_tax_rule_id%TYPE;

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

Line 1706: l_emp_fed_tax_rule_id hr_h2pi_federal_tax_rules.emp_fed_tax_rule_id%TYPE;

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

Line 2268: FROM hr_h2pi_federal_tax_rules_v

2264: hr_utility.set_location(l_proc, 200);
2265: BEGIN
2266: SELECT emp_fed_tax_rule_id
2267: INTO l_emp_fed_tax_rule_id
2268: FROM hr_h2pi_federal_tax_rules_v
2269: WHERE assignment_id = l_assignment_id
2270: AND v_ud_asg.effective_start_date BETWEEN effective_start_date
2271: AND effective_end_date;
2272:

Line 2279: FROM hr_h2pi_federal_tax_rules

2275: p_to_id => l_emp_fed_tax_rule_id);
2276: IF l_temp_id = -1 THEN
2277: SELECT emp_fed_tax_rule_id
2278: INTO l_ud_emp_fed_tax_rule_id
2279: FROM hr_h2pi_federal_tax_rules
2280: WHERE assignment_id = v_ud_asg.assignment_id
2281: AND client_id = p_from_client_id
2282: AND v_ud_asg.effective_start_date BETWEEN effective_start_date
2283: AND effective_end_date;

Line 3930: FROM hr_h2pi_federal_tax_rules fed

3926:
3927: CURSOR csr_ud_federal_tax_rule (p_fed_id NUMBER,
3928: p_esd DATE) IS
3929: SELECT *
3930: FROM hr_h2pi_federal_tax_rules fed
3931: WHERE fed.emp_fed_tax_rule_id = p_fed_id
3932: AND fed.client_id = p_from_client_id
3933: AND fed.effective_start_date = p_esd;
3934:

Line 3938: FROM hr_h2pi_federal_tax_rules_v fed

3934:
3935: CURSOR csr_ed_federal_tax_rule (p_fed_id NUMBER,
3936: p_esd DATE) IS
3937: SELECT *
3938: FROM hr_h2pi_federal_tax_rules_v fed
3939: WHERE fed.emp_fed_tax_rule_id = p_fed_id
3940: AND p_esd BETWEEN fed.effective_start_date
3941: AND fed.effective_end_date;
3942:

Line 3955: v_ud_fed hr_h2pi_federal_tax_rules%ROWTYPE;

3951: l_encoded_message VARCHAR2(200);
3952:
3953: l_proc VARCHAR2(72) := g_package||'upload_federal_tax_rule';
3954:
3955: v_ud_fed hr_h2pi_federal_tax_rules%ROWTYPE;
3956: v_ed_fed hr_h2pi_federal_tax_rules_v%ROWTYPE;
3957:
3958: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
3959: l_emp_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;

Line 3956: v_ed_fed hr_h2pi_federal_tax_rules_v%ROWTYPE;

3952:
3953: l_proc VARCHAR2(72) := g_package||'upload_federal_tax_rule';
3954:
3955: v_ud_fed hr_h2pi_federal_tax_rules%ROWTYPE;
3956: v_ed_fed hr_h2pi_federal_tax_rules_v%ROWTYPE;
3957:
3958: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
3959: l_emp_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;
3960: l_ovn pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;

Line 4004: p_table_name => 'HR_H2PI_FEDERAL_TAX_RULES',

4000: ROLLBACK;
4001: hr_utility.set_location(l_proc, 90);
4002: hr_h2pi_error.data_error
4003: (p_from_id => l_emp_fed_tax_rule_id,
4004: p_table_name => 'HR_H2PI_FEDERAL_TAX_RULES',
4005: p_message_level => 'FATAL',
4006: p_message_name => 'HR_289240_MAPPING_ID_INVALID');
4007: COMMIT;
4008: RAISE MAPPING_ID_INVALID;

Line 4129: UPDATE hr_h2pi_federal_tax_rules fed

4125: ,p_effective_end_date => l_eed
4126: );
4127:
4128: hr_utility.set_location(l_proc, 170);
4129: UPDATE hr_h2pi_federal_tax_rules fed
4130: SET status = 'C'
4131: WHERE fed.emp_fed_tax_rule_id = v_ud_fed.emp_fed_tax_rule_id
4132: AND fed.client_id = p_from_client_id
4133: AND fed.effective_start_date = v_ud_fed.effective_start_date

Line 4147: p_table_name => 'HR_H2PI_FEDERAL_TAX_RULES',

4143: hr_utility.set_location(l_proc, 190);
4144: l_encoded_message := fnd_message.get_encoded;
4145: hr_h2pi_error.data_error
4146: (p_from_id => v_ud_fed.emp_fed_tax_rule_id,
4147: p_table_name => 'HR_H2PI_FEDERAL_TAX_RULES',
4148: p_message_level => 'FATAL',
4149: p_message_text => l_encoded_message);
4150: COMMIT;
4151: RAISE;