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_STATE_TAX_RULES_F

Line 2299: p_table_name => 'PAY_US_EMP_STATE_TAX_RULES_F',

2295: hr_utility.set_location(l_proc, 210);
2296: FOR v_sta IN csr_state_tax_rule(l_assignment_id,
2297: v_ud_asg.effective_start_date) LOOP
2298: l_temp_id := hr_h2pi_map.get_from_id(
2299: p_table_name => 'PAY_US_EMP_STATE_TAX_RULES_F',
2300: p_to_id => v_sta.emp_state_tax_rule_id);
2301: IF l_temp_id = -1 THEN
2302:
2303: SELECT emp_state_tax_rule_id

Line 2313: (p_table_name => 'PAY_US_EMP_STATE_TAX_RULES_F',

2309: AND v_ud_asg.effective_start_date BETWEEN effective_start_date
2310: AND effective_end_date;
2311:
2312: hr_h2pi_map.create_id_mapping
2313: (p_table_name => 'PAY_US_EMP_STATE_TAX_RULES_F',
2314: p_from_id => l_ud_emp_state_tax_rule_id,
2315: p_to_id => v_sta.emp_state_tax_rule_id);
2316:
2317: END IF;

Line 4180: FROM pay_us_emp_state_tax_rules_f sta

4176:
4177: CURSOR csr_ed_state_tax_rule_ovn (p_sta_id NUMBER,
4178: p_esd DATE) IS
4179: SELECT sta.object_version_number
4180: FROM pay_us_emp_state_tax_rules_f sta
4181: WHERE sta.emp_state_tax_rule_id = p_sta_id
4182: AND p_esd BETWEEN sta.effective_start_date
4183: AND sta.effective_end_date;
4184:

Line 4194: pay_us_emp_state_tax_rules_f.emp_state_tax_rule_id%TYPE;

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;
4195: l_ovn pay_us_emp_state_tax_rules_f.object_version_number%TYPE;
4196: l_esd pay_us_emp_state_tax_rules_f.effective_start_date%TYPE;
4197: l_eed pay_us_emp_state_tax_rules_f.effective_end_date%TYPE;
4198:

Line 4195: l_ovn pay_us_emp_state_tax_rules_f.object_version_number%TYPE;

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;
4195: l_ovn pay_us_emp_state_tax_rules_f.object_version_number%TYPE;
4196: l_esd pay_us_emp_state_tax_rules_f.effective_start_date%TYPE;
4197: l_eed pay_us_emp_state_tax_rules_f.effective_end_date%TYPE;
4198:
4199: l_max_eed pay_us_emp_state_tax_rules_f.effective_end_date%TYPE;

Line 4196: l_esd pay_us_emp_state_tax_rules_f.effective_start_date%TYPE;

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;
4195: l_ovn pay_us_emp_state_tax_rules_f.object_version_number%TYPE;
4196: l_esd pay_us_emp_state_tax_rules_f.effective_start_date%TYPE;
4197: l_eed pay_us_emp_state_tax_rules_f.effective_end_date%TYPE;
4198:
4199: l_max_eed pay_us_emp_state_tax_rules_f.effective_end_date%TYPE;
4200: l_del_ovn pay_us_emp_state_tax_rules_f.object_version_number%TYPE;

Line 4197: l_eed pay_us_emp_state_tax_rules_f.effective_end_date%TYPE;

4193: l_emp_state_tax_rule_id
4194: pay_us_emp_state_tax_rules_f.emp_state_tax_rule_id%TYPE;
4195: l_ovn pay_us_emp_state_tax_rules_f.object_version_number%TYPE;
4196: l_esd pay_us_emp_state_tax_rules_f.effective_start_date%TYPE;
4197: l_eed pay_us_emp_state_tax_rules_f.effective_end_date%TYPE;
4198:
4199: l_max_eed pay_us_emp_state_tax_rules_f.effective_end_date%TYPE;
4200: l_del_ovn pay_us_emp_state_tax_rules_f.object_version_number%TYPE;
4201: l_del_esd pay_us_emp_state_tax_rules_f.effective_start_date%TYPE;

Line 4199: l_max_eed pay_us_emp_state_tax_rules_f.effective_end_date%TYPE;

4195: l_ovn pay_us_emp_state_tax_rules_f.object_version_number%TYPE;
4196: l_esd pay_us_emp_state_tax_rules_f.effective_start_date%TYPE;
4197: l_eed pay_us_emp_state_tax_rules_f.effective_end_date%TYPE;
4198:
4199: l_max_eed pay_us_emp_state_tax_rules_f.effective_end_date%TYPE;
4200: l_del_ovn pay_us_emp_state_tax_rules_f.object_version_number%TYPE;
4201: l_del_esd pay_us_emp_state_tax_rules_f.effective_start_date%TYPE;
4202: l_del_eed pay_us_emp_state_tax_rules_f.effective_end_date%TYPE;
4203: l_val_esd pay_us_emp_state_tax_rules_f.effective_start_date%TYPE;

Line 4200: l_del_ovn pay_us_emp_state_tax_rules_f.object_version_number%TYPE;

4196: l_esd pay_us_emp_state_tax_rules_f.effective_start_date%TYPE;
4197: l_eed pay_us_emp_state_tax_rules_f.effective_end_date%TYPE;
4198:
4199: l_max_eed pay_us_emp_state_tax_rules_f.effective_end_date%TYPE;
4200: l_del_ovn pay_us_emp_state_tax_rules_f.object_version_number%TYPE;
4201: l_del_esd pay_us_emp_state_tax_rules_f.effective_start_date%TYPE;
4202: l_del_eed pay_us_emp_state_tax_rules_f.effective_end_date%TYPE;
4203: l_val_esd pay_us_emp_state_tax_rules_f.effective_start_date%TYPE;
4204: l_val_eed pay_us_emp_state_tax_rules_f.effective_end_date%TYPE;

Line 4201: l_del_esd pay_us_emp_state_tax_rules_f.effective_start_date%TYPE;

4197: l_eed pay_us_emp_state_tax_rules_f.effective_end_date%TYPE;
4198:
4199: l_max_eed pay_us_emp_state_tax_rules_f.effective_end_date%TYPE;
4200: l_del_ovn pay_us_emp_state_tax_rules_f.object_version_number%TYPE;
4201: l_del_esd pay_us_emp_state_tax_rules_f.effective_start_date%TYPE;
4202: l_del_eed pay_us_emp_state_tax_rules_f.effective_end_date%TYPE;
4203: l_val_esd pay_us_emp_state_tax_rules_f.effective_start_date%TYPE;
4204: l_val_eed pay_us_emp_state_tax_rules_f.effective_end_date%TYPE;
4205: l_business_group_id pay_us_emp_state_tax_rules_f.business_group_id%TYPE;

Line 4202: l_del_eed pay_us_emp_state_tax_rules_f.effective_end_date%TYPE;

4198:
4199: l_max_eed pay_us_emp_state_tax_rules_f.effective_end_date%TYPE;
4200: l_del_ovn pay_us_emp_state_tax_rules_f.object_version_number%TYPE;
4201: l_del_esd pay_us_emp_state_tax_rules_f.effective_start_date%TYPE;
4202: l_del_eed pay_us_emp_state_tax_rules_f.effective_end_date%TYPE;
4203: l_val_esd pay_us_emp_state_tax_rules_f.effective_start_date%TYPE;
4204: l_val_eed pay_us_emp_state_tax_rules_f.effective_end_date%TYPE;
4205: l_business_group_id pay_us_emp_state_tax_rules_f.business_group_id%TYPE;
4206:

Line 4203: l_val_esd pay_us_emp_state_tax_rules_f.effective_start_date%TYPE;

4199: l_max_eed pay_us_emp_state_tax_rules_f.effective_end_date%TYPE;
4200: l_del_ovn pay_us_emp_state_tax_rules_f.object_version_number%TYPE;
4201: l_del_esd pay_us_emp_state_tax_rules_f.effective_start_date%TYPE;
4202: l_del_eed pay_us_emp_state_tax_rules_f.effective_end_date%TYPE;
4203: l_val_esd pay_us_emp_state_tax_rules_f.effective_start_date%TYPE;
4204: l_val_eed pay_us_emp_state_tax_rules_f.effective_end_date%TYPE;
4205: l_business_group_id pay_us_emp_state_tax_rules_f.business_group_id%TYPE;
4206:
4207: l_records_same BOOLEAN;

Line 4204: l_val_eed pay_us_emp_state_tax_rules_f.effective_end_date%TYPE;

4200: l_del_ovn pay_us_emp_state_tax_rules_f.object_version_number%TYPE;
4201: l_del_esd pay_us_emp_state_tax_rules_f.effective_start_date%TYPE;
4202: l_del_eed pay_us_emp_state_tax_rules_f.effective_end_date%TYPE;
4203: l_val_esd pay_us_emp_state_tax_rules_f.effective_start_date%TYPE;
4204: l_val_eed pay_us_emp_state_tax_rules_f.effective_end_date%TYPE;
4205: l_business_group_id pay_us_emp_state_tax_rules_f.business_group_id%TYPE;
4206:
4207: l_records_same BOOLEAN;
4208: l_future_records BOOLEAN;

Line 4205: l_business_group_id pay_us_emp_state_tax_rules_f.business_group_id%TYPE;

4201: l_del_esd pay_us_emp_state_tax_rules_f.effective_start_date%TYPE;
4202: l_del_eed pay_us_emp_state_tax_rules_f.effective_end_date%TYPE;
4203: l_val_esd pay_us_emp_state_tax_rules_f.effective_start_date%TYPE;
4204: l_val_eed pay_us_emp_state_tax_rules_f.effective_end_date%TYPE;
4205: l_business_group_id pay_us_emp_state_tax_rules_f.business_group_id%TYPE;
4206:
4207: l_records_same BOOLEAN;
4208: l_future_records BOOLEAN;
4209: l_update_mode VARCHAR2(30);

Line 4226: (p_table_name => 'PAY_US_EMP_STATE_TAX_RULES_F',

4222: p_from_id => v_ud_sta.assignment_id,
4223: p_report_error => TRUE);
4224:
4225: l_emp_state_tax_rule_id := hr_h2pi_map.get_to_id
4226: (p_table_name => 'PAY_US_EMP_STATE_TAX_RULES_F',
4227: p_from_id => v_ud_sta.emp_state_tax_rule_id);
4228:
4229: IF l_emp_state_tax_rule_id = -1 THEN
4230: hr_utility.set_location(l_proc, 30);

Line 4262: (p_table_name => 'PAY_US_EMP_STATE_TAX_RULES_F',

4258: );
4259:
4260: hr_utility.set_location(l_proc, 40);
4261: hr_h2pi_map.create_id_mapping
4262: (p_table_name => 'PAY_US_EMP_STATE_TAX_RULES_F',
4263: p_from_id => v_ud_sta.emp_state_tax_rule_id,
4264: p_to_id => l_emp_state_tax_rule_id);
4265: ELSE
4266:

Line 4303: FROM pay_us_emp_state_tax_rules_f sta

4299: l_records_same := FALSE;
4300:
4301: SELECT MAX(sta.effective_end_date)
4302: INTO l_max_eed
4303: FROM pay_us_emp_state_tax_rules_f sta
4304: WHERE sta.emp_state_tax_rule_id = l_emp_state_tax_rule_id;
4305:
4306: IF l_max_eed > v_ed_sta.effective_end_date THEN
4307: hr_utility.set_location(l_proc, 90);