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_COUNTY_TAX_RULES_F

Line 2324: p_table_name=> 'PAY_US_EMP_COUNTY_TAX_RULES_F',

2320: hr_utility.set_location(l_proc, 220);
2321: FOR v_cnt IN csr_county_tax_rule(l_assignment_id,
2322: v_ud_asg.effective_start_date) LOOP
2323: l_temp_id := hr_h2pi_map.get_from_id(
2324: p_table_name=> 'PAY_US_EMP_COUNTY_TAX_RULES_F',
2325: p_to_id => v_cnt.emp_county_tax_rule_id);
2326: IF l_temp_id = -1 THEN
2327:
2328: SELECT emp_county_tax_rule_id

Line 2338: (p_table_name => 'PAY_US_EMP_COUNTY_TAX_RULES_F',

2334: AND v_ud_asg.effective_start_date BETWEEN effective_start_date
2335: AND effective_end_date;
2336:
2337: hr_h2pi_map.create_id_mapping
2338: (p_table_name => 'PAY_US_EMP_COUNTY_TAX_RULES_F',
2339: p_from_id => l_ud_emp_county_tax_rule_id,
2340: p_to_id => v_cnt.emp_county_tax_rule_id);
2341:
2342: END IF;

Line 4461: FROM pay_us_emp_county_tax_rules_f cnt

4457:
4458: CURSOR csr_ed_county_tax_rule_ovn (p_cnt_id NUMBER,
4459: p_esd DATE) IS
4460: SELECT cnt.object_version_number
4461: FROM pay_us_emp_county_tax_rules_f cnt
4462: WHERE cnt.emp_county_tax_rule_id = p_cnt_id
4463: AND p_esd BETWEEN cnt.effective_start_date
4464: AND cnt.effective_end_date;
4465:

Line 4475: pay_us_emp_county_tax_rules_f.emp_county_tax_rule_id%TYPE;

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;
4476: l_ovn pay_us_emp_county_tax_rules_f.object_version_number%TYPE;
4477: l_esd pay_us_emp_county_tax_rules_f.effective_start_date%TYPE;
4478: l_eed pay_us_emp_county_tax_rules_f.effective_end_date%TYPE;
4479:

Line 4476: l_ovn pay_us_emp_county_tax_rules_f.object_version_number%TYPE;

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;
4476: l_ovn pay_us_emp_county_tax_rules_f.object_version_number%TYPE;
4477: l_esd pay_us_emp_county_tax_rules_f.effective_start_date%TYPE;
4478: l_eed pay_us_emp_county_tax_rules_f.effective_end_date%TYPE;
4479:
4480: l_max_eed pay_us_emp_county_tax_rules_f.effective_end_date%TYPE;

Line 4477: l_esd pay_us_emp_county_tax_rules_f.effective_start_date%TYPE;

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;
4476: l_ovn pay_us_emp_county_tax_rules_f.object_version_number%TYPE;
4477: l_esd pay_us_emp_county_tax_rules_f.effective_start_date%TYPE;
4478: l_eed pay_us_emp_county_tax_rules_f.effective_end_date%TYPE;
4479:
4480: l_max_eed pay_us_emp_county_tax_rules_f.effective_end_date%TYPE;
4481: l_del_ovn pay_us_emp_county_tax_rules_f.object_version_number%TYPE;

Line 4478: l_eed pay_us_emp_county_tax_rules_f.effective_end_date%TYPE;

4474: l_emp_county_tax_rule_id
4475: pay_us_emp_county_tax_rules_f.emp_county_tax_rule_id%TYPE;
4476: l_ovn pay_us_emp_county_tax_rules_f.object_version_number%TYPE;
4477: l_esd pay_us_emp_county_tax_rules_f.effective_start_date%TYPE;
4478: l_eed pay_us_emp_county_tax_rules_f.effective_end_date%TYPE;
4479:
4480: l_max_eed pay_us_emp_county_tax_rules_f.effective_end_date%TYPE;
4481: l_del_ovn pay_us_emp_county_tax_rules_f.object_version_number%TYPE;
4482: l_del_esd pay_us_emp_county_tax_rules_f.effective_start_date%TYPE;

Line 4480: l_max_eed pay_us_emp_county_tax_rules_f.effective_end_date%TYPE;

4476: l_ovn pay_us_emp_county_tax_rules_f.object_version_number%TYPE;
4477: l_esd pay_us_emp_county_tax_rules_f.effective_start_date%TYPE;
4478: l_eed pay_us_emp_county_tax_rules_f.effective_end_date%TYPE;
4479:
4480: l_max_eed pay_us_emp_county_tax_rules_f.effective_end_date%TYPE;
4481: l_del_ovn pay_us_emp_county_tax_rules_f.object_version_number%TYPE;
4482: l_del_esd pay_us_emp_county_tax_rules_f.effective_start_date%TYPE;
4483: l_del_eed pay_us_emp_county_tax_rules_f.effective_end_date%TYPE;
4484: l_val_esd pay_us_emp_county_tax_rules_f.effective_start_date%TYPE;

Line 4481: l_del_ovn pay_us_emp_county_tax_rules_f.object_version_number%TYPE;

4477: l_esd pay_us_emp_county_tax_rules_f.effective_start_date%TYPE;
4478: l_eed pay_us_emp_county_tax_rules_f.effective_end_date%TYPE;
4479:
4480: l_max_eed pay_us_emp_county_tax_rules_f.effective_end_date%TYPE;
4481: l_del_ovn pay_us_emp_county_tax_rules_f.object_version_number%TYPE;
4482: l_del_esd pay_us_emp_county_tax_rules_f.effective_start_date%TYPE;
4483: l_del_eed pay_us_emp_county_tax_rules_f.effective_end_date%TYPE;
4484: l_val_esd pay_us_emp_county_tax_rules_f.effective_start_date%TYPE;
4485: l_val_eed pay_us_emp_county_tax_rules_f.effective_end_date%TYPE;

Line 4482: l_del_esd pay_us_emp_county_tax_rules_f.effective_start_date%TYPE;

4478: l_eed pay_us_emp_county_tax_rules_f.effective_end_date%TYPE;
4479:
4480: l_max_eed pay_us_emp_county_tax_rules_f.effective_end_date%TYPE;
4481: l_del_ovn pay_us_emp_county_tax_rules_f.object_version_number%TYPE;
4482: l_del_esd pay_us_emp_county_tax_rules_f.effective_start_date%TYPE;
4483: l_del_eed pay_us_emp_county_tax_rules_f.effective_end_date%TYPE;
4484: l_val_esd pay_us_emp_county_tax_rules_f.effective_start_date%TYPE;
4485: l_val_eed pay_us_emp_county_tax_rules_f.effective_end_date%TYPE;
4486: l_business_group_id pay_us_emp_county_tax_rules_f.business_group_id%TYPE;

Line 4483: l_del_eed pay_us_emp_county_tax_rules_f.effective_end_date%TYPE;

4479:
4480: l_max_eed pay_us_emp_county_tax_rules_f.effective_end_date%TYPE;
4481: l_del_ovn pay_us_emp_county_tax_rules_f.object_version_number%TYPE;
4482: l_del_esd pay_us_emp_county_tax_rules_f.effective_start_date%TYPE;
4483: l_del_eed pay_us_emp_county_tax_rules_f.effective_end_date%TYPE;
4484: l_val_esd pay_us_emp_county_tax_rules_f.effective_start_date%TYPE;
4485: l_val_eed pay_us_emp_county_tax_rules_f.effective_end_date%TYPE;
4486: l_business_group_id pay_us_emp_county_tax_rules_f.business_group_id%TYPE;
4487:

Line 4484: l_val_esd pay_us_emp_county_tax_rules_f.effective_start_date%TYPE;

4480: l_max_eed pay_us_emp_county_tax_rules_f.effective_end_date%TYPE;
4481: l_del_ovn pay_us_emp_county_tax_rules_f.object_version_number%TYPE;
4482: l_del_esd pay_us_emp_county_tax_rules_f.effective_start_date%TYPE;
4483: l_del_eed pay_us_emp_county_tax_rules_f.effective_end_date%TYPE;
4484: l_val_esd pay_us_emp_county_tax_rules_f.effective_start_date%TYPE;
4485: l_val_eed pay_us_emp_county_tax_rules_f.effective_end_date%TYPE;
4486: l_business_group_id pay_us_emp_county_tax_rules_f.business_group_id%TYPE;
4487:
4488: l_records_same BOOLEAN;

Line 4485: l_val_eed pay_us_emp_county_tax_rules_f.effective_end_date%TYPE;

4481: l_del_ovn pay_us_emp_county_tax_rules_f.object_version_number%TYPE;
4482: l_del_esd pay_us_emp_county_tax_rules_f.effective_start_date%TYPE;
4483: l_del_eed pay_us_emp_county_tax_rules_f.effective_end_date%TYPE;
4484: l_val_esd pay_us_emp_county_tax_rules_f.effective_start_date%TYPE;
4485: l_val_eed pay_us_emp_county_tax_rules_f.effective_end_date%TYPE;
4486: l_business_group_id pay_us_emp_county_tax_rules_f.business_group_id%TYPE;
4487:
4488: l_records_same BOOLEAN;
4489: l_future_records BOOLEAN;

Line 4486: l_business_group_id pay_us_emp_county_tax_rules_f.business_group_id%TYPE;

4482: l_del_esd pay_us_emp_county_tax_rules_f.effective_start_date%TYPE;
4483: l_del_eed pay_us_emp_county_tax_rules_f.effective_end_date%TYPE;
4484: l_val_esd pay_us_emp_county_tax_rules_f.effective_start_date%TYPE;
4485: l_val_eed pay_us_emp_county_tax_rules_f.effective_end_date%TYPE;
4486: l_business_group_id pay_us_emp_county_tax_rules_f.business_group_id%TYPE;
4487:
4488: l_records_same BOOLEAN;
4489: l_future_records BOOLEAN;
4490: l_update_mode VARCHAR2(30);

Line 4507: (p_table_name => 'PAY_US_EMP_COUNTY_TAX_RULES_F',

4503: p_from_id => v_ud_cnt.assignment_id,
4504: p_report_error => TRUE);
4505:
4506: l_emp_county_tax_rule_id := hr_h2pi_map.get_to_id
4507: (p_table_name => 'PAY_US_EMP_COUNTY_TAX_RULES_F',
4508: p_from_id => v_ud_cnt.emp_county_tax_rule_id);
4509:
4510: IF l_emp_county_tax_rule_id = -1 THEN
4511: hr_utility.set_location(l_proc, 30);

Line 4535: (p_table_name => 'PAY_US_EMP_COUNTY_TAX_RULES_F',

4531: );
4532:
4533: hr_utility.set_location(l_proc, 40);
4534: hr_h2pi_map.create_id_mapping
4535: (p_table_name => 'PAY_US_EMP_COUNTY_TAX_RULES_F',
4536: p_from_id => v_ud_cnt.emp_county_tax_rule_id,
4537: p_to_id => l_emp_county_tax_rule_id);
4538: ELSE
4539:

Line 4576: FROM pay_us_emp_county_tax_rules_f cnt

4572: l_records_same := FALSE;
4573:
4574: SELECT MAX(cnt.effective_end_date)
4575: INTO l_max_eed
4576: FROM pay_us_emp_county_tax_rules_f cnt
4577: WHERE cnt.emp_county_tax_rule_id = l_emp_county_tax_rule_id;
4578:
4579: IF l_max_eed > v_ed_cnt.effective_end_date THEN
4580: hr_utility.set_location(l_proc, 90);