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_CITY_TAX_RULES_F

Line 2349: p_table_name => 'PAY_US_EMP_CITY_TAX_RULES_F',

2345: hr_utility.set_location(l_proc, 230);
2346: FOR v_cty IN csr_city_tax_rule(l_assignment_id,
2347: v_ud_asg.effective_start_date) LOOP
2348: l_temp_id := hr_h2pi_map.get_from_id(
2349: p_table_name => 'PAY_US_EMP_CITY_TAX_RULES_F',
2350: p_to_id => v_cty.emp_city_tax_rule_id);
2351: IF l_temp_id = -1 THEN
2352:
2353: SELECT emp_city_tax_rule_id

Line 2363: (p_table_name => 'PAY_US_EMP_CITY_TAX_RULES_F',

2359: AND v_ud_asg.effective_start_date BETWEEN effective_start_date
2360: AND effective_end_date;
2361:
2362: hr_h2pi_map.create_id_mapping
2363: (p_table_name => 'PAY_US_EMP_CITY_TAX_RULES_F',
2364: p_from_id => l_ud_emp_city_tax_rule_id,
2365: p_to_id => v_cty.emp_city_tax_rule_id);
2366:
2367: END IF;

Line 4716: FROM pay_us_emp_city_tax_rules_f cty

4712:
4713: CURSOR csr_ed_city_tax_rule_ovn (p_cty_id NUMBER,
4714: p_esd DATE) IS
4715: SELECT cty.object_version_number
4716: FROM pay_us_emp_city_tax_rules_f cty
4717: WHERE cty.emp_city_tax_rule_id = p_cty_id
4718: AND p_esd BETWEEN cty.effective_start_date
4719: AND cty.effective_end_date;
4720:

Line 4730: pay_us_emp_city_tax_rules_f.emp_city_tax_rule_id%TYPE;

4726: v_ed_cty hr_h2pi_city_tax_rules_v%ROWTYPE;
4727:
4728: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
4729: l_emp_city_tax_rule_id
4730: pay_us_emp_city_tax_rules_f.emp_city_tax_rule_id%TYPE;
4731: l_ovn pay_us_emp_city_tax_rules_f.object_version_number%TYPE;
4732: l_esd pay_us_emp_city_tax_rules_f.effective_start_date%TYPE;
4733: l_eed pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;
4734:

Line 4731: l_ovn pay_us_emp_city_tax_rules_f.object_version_number%TYPE;

4727:
4728: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
4729: l_emp_city_tax_rule_id
4730: pay_us_emp_city_tax_rules_f.emp_city_tax_rule_id%TYPE;
4731: l_ovn pay_us_emp_city_tax_rules_f.object_version_number%TYPE;
4732: l_esd pay_us_emp_city_tax_rules_f.effective_start_date%TYPE;
4733: l_eed pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;
4734:
4735: l_max_eed pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;

Line 4732: l_esd pay_us_emp_city_tax_rules_f.effective_start_date%TYPE;

4728: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
4729: l_emp_city_tax_rule_id
4730: pay_us_emp_city_tax_rules_f.emp_city_tax_rule_id%TYPE;
4731: l_ovn pay_us_emp_city_tax_rules_f.object_version_number%TYPE;
4732: l_esd pay_us_emp_city_tax_rules_f.effective_start_date%TYPE;
4733: l_eed pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;
4734:
4735: l_max_eed pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;
4736: l_del_ovn pay_us_emp_city_tax_rules_f.object_version_number%TYPE;

Line 4733: l_eed pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;

4729: l_emp_city_tax_rule_id
4730: pay_us_emp_city_tax_rules_f.emp_city_tax_rule_id%TYPE;
4731: l_ovn pay_us_emp_city_tax_rules_f.object_version_number%TYPE;
4732: l_esd pay_us_emp_city_tax_rules_f.effective_start_date%TYPE;
4733: l_eed pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;
4734:
4735: l_max_eed pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;
4736: l_del_ovn pay_us_emp_city_tax_rules_f.object_version_number%TYPE;
4737: l_del_esd pay_us_emp_city_tax_rules_f.effective_start_date%TYPE;

Line 4735: l_max_eed pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;

4731: l_ovn pay_us_emp_city_tax_rules_f.object_version_number%TYPE;
4732: l_esd pay_us_emp_city_tax_rules_f.effective_start_date%TYPE;
4733: l_eed pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;
4734:
4735: l_max_eed pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;
4736: l_del_ovn pay_us_emp_city_tax_rules_f.object_version_number%TYPE;
4737: l_del_esd pay_us_emp_city_tax_rules_f.effective_start_date%TYPE;
4738: l_del_eed pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;
4739: l_val_esd pay_us_emp_city_tax_rules_f.effective_start_date%TYPE;

Line 4736: l_del_ovn pay_us_emp_city_tax_rules_f.object_version_number%TYPE;

4732: l_esd pay_us_emp_city_tax_rules_f.effective_start_date%TYPE;
4733: l_eed pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;
4734:
4735: l_max_eed pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;
4736: l_del_ovn pay_us_emp_city_tax_rules_f.object_version_number%TYPE;
4737: l_del_esd pay_us_emp_city_tax_rules_f.effective_start_date%TYPE;
4738: l_del_eed pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;
4739: l_val_esd pay_us_emp_city_tax_rules_f.effective_start_date%TYPE;
4740: l_val_eed pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;

Line 4737: l_del_esd pay_us_emp_city_tax_rules_f.effective_start_date%TYPE;

4733: l_eed pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;
4734:
4735: l_max_eed pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;
4736: l_del_ovn pay_us_emp_city_tax_rules_f.object_version_number%TYPE;
4737: l_del_esd pay_us_emp_city_tax_rules_f.effective_start_date%TYPE;
4738: l_del_eed pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;
4739: l_val_esd pay_us_emp_city_tax_rules_f.effective_start_date%TYPE;
4740: l_val_eed pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;
4741: l_business_group_id pay_us_emp_city_tax_rules_f.business_group_id%TYPE;

Line 4738: l_del_eed pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;

4734:
4735: l_max_eed pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;
4736: l_del_ovn pay_us_emp_city_tax_rules_f.object_version_number%TYPE;
4737: l_del_esd pay_us_emp_city_tax_rules_f.effective_start_date%TYPE;
4738: l_del_eed pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;
4739: l_val_esd pay_us_emp_city_tax_rules_f.effective_start_date%TYPE;
4740: l_val_eed pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;
4741: l_business_group_id pay_us_emp_city_tax_rules_f.business_group_id%TYPE;
4742:

Line 4739: l_val_esd pay_us_emp_city_tax_rules_f.effective_start_date%TYPE;

4735: l_max_eed pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;
4736: l_del_ovn pay_us_emp_city_tax_rules_f.object_version_number%TYPE;
4737: l_del_esd pay_us_emp_city_tax_rules_f.effective_start_date%TYPE;
4738: l_del_eed pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;
4739: l_val_esd pay_us_emp_city_tax_rules_f.effective_start_date%TYPE;
4740: l_val_eed pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;
4741: l_business_group_id pay_us_emp_city_tax_rules_f.business_group_id%TYPE;
4742:
4743: l_records_same BOOLEAN;

Line 4740: l_val_eed pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;

4736: l_del_ovn pay_us_emp_city_tax_rules_f.object_version_number%TYPE;
4737: l_del_esd pay_us_emp_city_tax_rules_f.effective_start_date%TYPE;
4738: l_del_eed pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;
4739: l_val_esd pay_us_emp_city_tax_rules_f.effective_start_date%TYPE;
4740: l_val_eed pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;
4741: l_business_group_id pay_us_emp_city_tax_rules_f.business_group_id%TYPE;
4742:
4743: l_records_same BOOLEAN;
4744: l_future_records BOOLEAN;

Line 4741: l_business_group_id pay_us_emp_city_tax_rules_f.business_group_id%TYPE;

4737: l_del_esd pay_us_emp_city_tax_rules_f.effective_start_date%TYPE;
4738: l_del_eed pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;
4739: l_val_esd pay_us_emp_city_tax_rules_f.effective_start_date%TYPE;
4740: l_val_eed pay_us_emp_city_tax_rules_f.effective_end_date%TYPE;
4741: l_business_group_id pay_us_emp_city_tax_rules_f.business_group_id%TYPE;
4742:
4743: l_records_same BOOLEAN;
4744: l_future_records BOOLEAN;
4745: l_update_mode VARCHAR2(30);

Line 4762: (p_table_name => 'PAY_US_EMP_CITY_TAX_RULES_F',

4758: p_from_id => v_ud_cty.assignment_id,
4759: p_report_error => TRUE);
4760:
4761: l_emp_city_tax_rule_id := hr_h2pi_map.get_to_id
4762: (p_table_name => 'PAY_US_EMP_CITY_TAX_RULES_F',
4763: p_from_id => v_ud_cty.emp_city_tax_rule_id);
4764:
4765: IF l_emp_city_tax_rule_id = -1 THEN
4766: hr_utility.set_location(l_proc, 30);

Line 4791: (p_table_name => 'PAY_US_EMP_CITY_TAX_RULES_F',

4787: );
4788:
4789: hr_utility.set_location(l_proc, 40);
4790: hr_h2pi_map.create_id_mapping
4791: (p_table_name => 'PAY_US_EMP_CITY_TAX_RULES_F',
4792: p_from_id => v_ud_cty.emp_city_tax_rule_id,
4793: p_to_id => l_emp_city_tax_rule_id);
4794: ELSE
4795:

Line 4832: FROM pay_us_emp_city_tax_rules_f sta

4828: l_records_same := FALSE;
4829:
4830: SELECT MAX(sta.effective_end_date)
4831: INTO l_max_eed
4832: FROM pay_us_emp_city_tax_rules_f sta
4833: WHERE sta.emp_city_tax_rule_id = l_emp_city_tax_rule_id;
4834:
4835: IF l_max_eed > v_ed_cty.effective_end_date THEN
4836: hr_utility.set_location(l_proc, 90);