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 PAY_US_EMP_FED_TAX_RULES_F

Line 2274: p_table_name => 'PAY_US_EMP_FED_TAX_RULES_F',

2270: AND v_ud_asg.effective_start_date BETWEEN effective_start_date
2271: AND effective_end_date;
2272:
2273: l_temp_id := hr_h2pi_map.get_from_id(
2274: p_table_name => 'PAY_US_EMP_FED_TAX_RULES_F',
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

Line 2286: (p_table_name => 'PAY_US_EMP_FED_TAX_RULES_F',

2282: AND v_ud_asg.effective_start_date BETWEEN effective_start_date
2283: AND effective_end_date;
2284:
2285: hr_h2pi_map.create_id_mapping
2286: (p_table_name => 'PAY_US_EMP_FED_TAX_RULES_F',
2287: p_from_id => l_ud_emp_fed_tax_rule_id,
2288: p_to_id => l_emp_fed_tax_rule_id);
2289: END IF;
2290: EXCEPTION

Line 3946: FROM pay_us_emp_fed_tax_rules_f fed

3942:
3943: CURSOR csr_ed_federal_tax_rule_ovn (p_fed_id NUMBER,
3944: p_esd DATE) IS
3945: SELECT fed.object_version_number
3946: FROM pay_us_emp_fed_tax_rules_f fed
3947: WHERE fed.emp_fed_tax_rule_id = p_fed_id
3948: AND p_esd BETWEEN fed.effective_start_date
3949: AND fed.effective_end_date;
3950:

Line 3959: l_emp_fed_tax_rule_id pay_us_emp_fed_tax_rules_f.emp_fed_tax_rule_id%TYPE;

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;
3961: l_esd pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
3962: l_eed pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
3963:

Line 3960: l_ovn pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;

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;
3961: l_esd pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
3962: l_eed pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
3963:
3964: l_max_eed pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;

Line 3961: l_esd pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;

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;
3961: l_esd pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
3962: l_eed pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
3963:
3964: l_max_eed pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
3965: l_del_ovn pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;

Line 3962: l_eed pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;

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;
3961: l_esd pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
3962: l_eed pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
3963:
3964: l_max_eed pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
3965: l_del_ovn pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
3966: l_del_esd pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;

Line 3964: l_max_eed pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;

3960: l_ovn pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
3961: l_esd pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
3962: l_eed pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
3963:
3964: l_max_eed pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
3965: l_del_ovn pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
3966: l_del_esd pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
3967: l_del_eed pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
3968: l_val_esd pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;

Line 3965: l_del_ovn pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;

3961: l_esd pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
3962: l_eed pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
3963:
3964: l_max_eed pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
3965: l_del_ovn pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
3966: l_del_esd pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
3967: l_del_eed pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
3968: l_val_esd pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
3969: l_val_eed pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;

Line 3966: l_del_esd pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;

3962: l_eed pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
3963:
3964: l_max_eed pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
3965: l_del_ovn pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
3966: l_del_esd pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
3967: l_del_eed pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
3968: l_val_esd pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
3969: l_val_eed pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
3970: l_business_group_id pay_us_emp_fed_tax_rules_f.business_group_id%TYPE;

Line 3967: l_del_eed pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;

3963:
3964: l_max_eed pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
3965: l_del_ovn pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
3966: l_del_esd pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
3967: l_del_eed pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
3968: l_val_esd pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
3969: l_val_eed pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
3970: l_business_group_id pay_us_emp_fed_tax_rules_f.business_group_id%TYPE;
3971:

Line 3968: l_val_esd pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;

3964: l_max_eed pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
3965: l_del_ovn pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
3966: l_del_esd pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
3967: l_del_eed pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
3968: l_val_esd pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
3969: l_val_eed pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
3970: l_business_group_id pay_us_emp_fed_tax_rules_f.business_group_id%TYPE;
3971:
3972: l_records_same BOOLEAN;

Line 3969: l_val_eed pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;

3965: l_del_ovn pay_us_emp_fed_tax_rules_f.object_version_number%TYPE;
3966: l_del_esd pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
3967: l_del_eed pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
3968: l_val_esd pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
3969: l_val_eed pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
3970: l_business_group_id pay_us_emp_fed_tax_rules_f.business_group_id%TYPE;
3971:
3972: l_records_same BOOLEAN;
3973: l_future_records BOOLEAN;

Line 3970: l_business_group_id pay_us_emp_fed_tax_rules_f.business_group_id%TYPE;

3966: l_del_esd pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
3967: l_del_eed pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
3968: l_val_esd pay_us_emp_fed_tax_rules_f.effective_start_date%TYPE;
3969: l_val_eed pay_us_emp_fed_tax_rules_f.effective_end_date%TYPE;
3970: l_business_group_id pay_us_emp_fed_tax_rules_f.business_group_id%TYPE;
3971:
3972: l_records_same BOOLEAN;
3973: l_future_records BOOLEAN;
3974: l_update_mode VARCHAR2(30);

Line 3986: (p_table_name => 'PAY_US_EMP_FED_TAX_RULES_F',

3982: FETCH csr_ud_federal_tax_rule INTO v_ud_fed;
3983:
3984: hr_utility.set_location(l_proc, 40);
3985: l_emp_fed_tax_rule_id := hr_h2pi_map.get_to_id
3986: (p_table_name => 'PAY_US_EMP_FED_TAX_RULES_F',
3987: p_from_id => v_ud_fed.emp_fed_tax_rule_id,
3988: p_report_error => TRUE);
3989:
3990:

Line 4027: FROM pay_us_emp_fed_tax_rules_f fed

4023: l_records_same := FALSE;
4024:
4025: SELECT MAX(fed.effective_end_date)
4026: INTO l_max_eed
4027: FROM pay_us_emp_fed_tax_rules_f fed
4028: WHERE fed.emp_fed_tax_rule_id = l_emp_fed_tax_rule_id;
4029:
4030: IF l_max_eed > v_ed_fed.effective_end_date THEN
4031: hr_utility.set_location(l_proc, 110);