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 PER_ALL_ASSIGNMENTS_F

Line 713: l_ud_assignment_id per_all_assignments_f.assignment_id%TYPE;

709:
710: v_ud_per hr_h2pi_employees%ROWTYPE;
711:
712: l_ud_person_id per_all_people_f.person_id%TYPE;
713: l_ud_assignment_id per_all_assignments_f.assignment_id%TYPE;
714: l_ud_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;
715:
716: l_person_id per_all_people_f.person_id%TYPE;
717: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

Line 717: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

713: l_ud_assignment_id per_all_assignments_f.assignment_id%TYPE;
714: l_ud_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;
715:
716: l_person_id per_all_people_f.person_id%TYPE;
717: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
718: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;
719: l_person_type per_person_types.system_person_type%TYPE;
720: l_ovn per_all_people_f.object_version_number%TYPE;
721: l_asg_ovn per_all_people_f.object_version_number%TYPE;

Line 726: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;

722: l_esd per_all_people_f.effective_start_date%TYPE;
723: l_eed per_all_people_f.effective_end_date%TYPE;
724: l_comment_id per_all_people_f.comment_id%TYPE;
725: l_full_name per_all_people_f.full_name%TYPE;
726: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
727: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
728: l_name_combination_warning BOOLEAN;
729: l_assign_payroll_warning BOOLEAN;
730: l_orig_hire_warning BOOLEAN;

Line 727: l_assignment_number per_all_assignments_f.assignment_number%TYPE;

723: l_eed per_all_people_f.effective_end_date%TYPE;
724: l_comment_id per_all_people_f.comment_id%TYPE;
725: l_full_name per_all_people_f.full_name%TYPE;
726: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
727: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
728: l_name_combination_warning BOOLEAN;
729: l_assign_payroll_warning BOOLEAN;
730: l_orig_hire_warning BOOLEAN;
731:

Line 870: (p_table_name => 'PER_ALL_ASSIGNMENTS_F',

866: AND asg.effective_start_date = v_ud_per.effective_start_date
867: AND asg.primary_flag = 'Y';
868:
869: hr_h2pi_map.create_id_mapping
870: (p_table_name => 'PER_ALL_ASSIGNMENTS_F',
871: p_from_id => l_ud_assignment_id,
872: p_to_id => l_assignment_id);
873: BEGIN
874: SELECT pos.period_of_service_id

Line 1105: (p_table_name => 'PER_ALL_ASSIGNMENTS_F',

1101: AND asg.effective_start_date = v_ud_per.effective_start_date
1102: AND asg.primary_flag = 'Y';
1103:
1104: hr_h2pi_map.create_id_mapping
1105: (p_table_name => 'PER_ALL_ASSIGNMENTS_F',
1106: p_from_id => l_ud_assignment_id,
1107: p_to_id => l_assignment_id);
1108:
1109: BEGIN

Line 1598: FROM per_all_assignments_f asg

1594:
1595: CURSOR csr_ed_assignment_ovn (p_asg_id NUMBER,
1596: p_esd DATE) IS
1597: SELECT asg.object_version_number
1598: FROM per_all_assignments_f asg
1599: WHERE asg.assignment_id = p_asg_id
1600: AND p_esd BETWEEN asg.effective_start_date
1601: AND asg.effective_end_date;
1602:

Line 1607: FROM per_all_assignments_f asg,

1603: CURSOR csr_ed_periods_of_service(p_asg_id NUMBER,
1604: p_esd DATE) IS
1605: SELECT pos.object_version_number,
1606: pos.period_of_service_id
1607: FROM per_all_assignments_f asg,
1608: per_all_people_f per,
1609: per_periods_of_service pos
1610: WHERE asg.assignment_id = p_asg_id
1611: AND p_esd BETWEEN asg.effective_start_date

Line 1655: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

1651: v_ed_asg hr_h2pi_assignments_v%ROWTYPE;
1652: v_ud_pos hr_h2pi_periods_of_service%ROWTYPE;
1653:
1654: l_person_id per_all_people_f.person_id%TYPE;
1655: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
1656: l_period_of_service_id per_periods_of_service.period_of_service_id%TYPE;
1657: l_ovn per_all_people_f.object_version_number%TYPE;
1658: l_pos_ovn per_all_people_f.object_version_number%TYPE;
1659: l_esd per_all_people_f.effective_start_date%TYPE;

Line 1661: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;

1657: l_ovn per_all_people_f.object_version_number%TYPE;
1658: l_pos_ovn per_all_people_f.object_version_number%TYPE;
1659: l_esd per_all_people_f.effective_start_date%TYPE;
1660: l_eed per_all_people_f.effective_end_date%TYPE;
1661: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
1662: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
1663:
1664: l_max_eed per_all_assignments_f.effective_end_date%TYPE;
1665: l_del_ovn per_all_assignments_f.object_version_number%TYPE;

Line 1662: l_assignment_number per_all_assignments_f.assignment_number%TYPE;

1658: l_pos_ovn per_all_people_f.object_version_number%TYPE;
1659: l_esd per_all_people_f.effective_start_date%TYPE;
1660: l_eed per_all_people_f.effective_end_date%TYPE;
1661: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
1662: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
1663:
1664: l_max_eed per_all_assignments_f.effective_end_date%TYPE;
1665: l_del_ovn per_all_assignments_f.object_version_number%TYPE;
1666: l_del_esd per_all_assignments_f.effective_start_date%TYPE;

Line 1664: l_max_eed per_all_assignments_f.effective_end_date%TYPE;

1660: l_eed per_all_people_f.effective_end_date%TYPE;
1661: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
1662: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
1663:
1664: l_max_eed per_all_assignments_f.effective_end_date%TYPE;
1665: l_del_ovn per_all_assignments_f.object_version_number%TYPE;
1666: l_del_esd per_all_assignments_f.effective_start_date%TYPE;
1667: l_del_eed per_all_assignments_f.effective_end_date%TYPE;
1668: l_val_esd per_all_assignments_f.effective_start_date%TYPE;

Line 1665: l_del_ovn per_all_assignments_f.object_version_number%TYPE;

1661: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
1662: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
1663:
1664: l_max_eed per_all_assignments_f.effective_end_date%TYPE;
1665: l_del_ovn per_all_assignments_f.object_version_number%TYPE;
1666: l_del_esd per_all_assignments_f.effective_start_date%TYPE;
1667: l_del_eed per_all_assignments_f.effective_end_date%TYPE;
1668: l_val_esd per_all_assignments_f.effective_start_date%TYPE;
1669: l_val_eed per_all_assignments_f.effective_end_date%TYPE;

Line 1666: l_del_esd per_all_assignments_f.effective_start_date%TYPE;

1662: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
1663:
1664: l_max_eed per_all_assignments_f.effective_end_date%TYPE;
1665: l_del_ovn per_all_assignments_f.object_version_number%TYPE;
1666: l_del_esd per_all_assignments_f.effective_start_date%TYPE;
1667: l_del_eed per_all_assignments_f.effective_end_date%TYPE;
1668: l_val_esd per_all_assignments_f.effective_start_date%TYPE;
1669: l_val_eed per_all_assignments_f.effective_end_date%TYPE;
1670: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

Line 1667: l_del_eed per_all_assignments_f.effective_end_date%TYPE;

1663:
1664: l_max_eed per_all_assignments_f.effective_end_date%TYPE;
1665: l_del_ovn per_all_assignments_f.object_version_number%TYPE;
1666: l_del_esd per_all_assignments_f.effective_start_date%TYPE;
1667: l_del_eed per_all_assignments_f.effective_end_date%TYPE;
1668: l_val_esd per_all_assignments_f.effective_start_date%TYPE;
1669: l_val_eed per_all_assignments_f.effective_end_date%TYPE;
1670: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
1671:

Line 1668: l_val_esd per_all_assignments_f.effective_start_date%TYPE;

1664: l_max_eed per_all_assignments_f.effective_end_date%TYPE;
1665: l_del_ovn per_all_assignments_f.object_version_number%TYPE;
1666: l_del_esd per_all_assignments_f.effective_start_date%TYPE;
1667: l_del_eed per_all_assignments_f.effective_end_date%TYPE;
1668: l_val_esd per_all_assignments_f.effective_start_date%TYPE;
1669: l_val_eed per_all_assignments_f.effective_end_date%TYPE;
1670: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
1671:
1672: l_records_same BOOLEAN;

Line 1669: l_val_eed per_all_assignments_f.effective_end_date%TYPE;

1665: l_del_ovn per_all_assignments_f.object_version_number%TYPE;
1666: l_del_esd per_all_assignments_f.effective_start_date%TYPE;
1667: l_del_eed per_all_assignments_f.effective_end_date%TYPE;
1668: l_val_esd per_all_assignments_f.effective_start_date%TYPE;
1669: l_val_eed per_all_assignments_f.effective_end_date%TYPE;
1670: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
1671:
1672: l_records_same BOOLEAN;
1673: l_future_records BOOLEAN;

Line 1670: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

1666: l_del_esd per_all_assignments_f.effective_start_date%TYPE;
1667: l_del_eed per_all_assignments_f.effective_end_date%TYPE;
1668: l_val_esd per_all_assignments_f.effective_start_date%TYPE;
1669: l_val_eed per_all_assignments_f.effective_end_date%TYPE;
1670: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
1671:
1672: l_records_same BOOLEAN;
1673: l_future_records BOOLEAN;
1674: l_update_mode VARCHAR2(30);

Line 1683: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;

1679: l_entries_changed_warning VARCHAR2(1);
1680: l_pay_proposal_warning BOOLEAN;
1681: l_group_name VARCHAR2(100);
1682: l_concatenated_segments VARCHAR2(2000);
1683: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
1684: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
1685: l_comment_id per_all_assignments_f.comment_id%TYPE;
1686: l_other_manager_warning BOOLEAN;
1687: l_no_manager_warning BOOLEAN;

Line 1684: l_people_group_id per_all_assignments_f.people_group_id%TYPE;

1680: l_pay_proposal_warning BOOLEAN;
1681: l_group_name VARCHAR2(100);
1682: l_concatenated_segments VARCHAR2(2000);
1683: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
1684: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
1685: l_comment_id per_all_assignments_f.comment_id%TYPE;
1686: l_other_manager_warning BOOLEAN;
1687: l_no_manager_warning BOOLEAN;
1688: l_concat_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;

Line 1685: l_comment_id per_all_assignments_f.comment_id%TYPE;

1681: l_group_name VARCHAR2(100);
1682: l_concatenated_segments VARCHAR2(2000);
1683: l_soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%TYPE;
1684: l_people_group_id per_all_assignments_f.people_group_id%TYPE;
1685: l_comment_id per_all_assignments_f.comment_id%TYPE;
1686: l_other_manager_warning BOOLEAN;
1687: l_no_manager_warning BOOLEAN;
1688: l_concat_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
1689: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE;

Line 1689: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE;

1685: l_comment_id per_all_assignments_f.comment_id%TYPE;
1686: l_other_manager_warning BOOLEAN;
1687: l_no_manager_warning BOOLEAN;
1688: l_concat_segments hr_soft_coding_keyflex.concatenated_segments%TYPE;
1689: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE;
1690: l_spp_delete_warning BOOLEAN;
1691: l_tax_district_changed_warning BOOLEAN;
1692:
1693: l_organization_id per_all_assignments_f.organization_id%TYPE;

Line 1693: l_organization_id per_all_assignments_f.organization_id%TYPE;

1689: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE;
1690: l_spp_delete_warning BOOLEAN;
1691: l_tax_district_changed_warning BOOLEAN;
1692:
1693: l_organization_id per_all_assignments_f.organization_id%TYPE;
1694: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
1695: l_location_id per_all_assignments_f.location_id%TYPE;
1696: l_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;
1697: l_gre_id NUMBER(15);

Line 1694: l_payroll_id per_all_assignments_f.payroll_id%TYPE;

1690: l_spp_delete_warning BOOLEAN;
1691: l_tax_district_changed_warning BOOLEAN;
1692:
1693: l_organization_id per_all_assignments_f.organization_id%TYPE;
1694: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
1695: l_location_id per_all_assignments_f.location_id%TYPE;
1696: l_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;
1697: l_gre_id NUMBER(15);
1698:

Line 1695: l_location_id per_all_assignments_f.location_id%TYPE;

1691: l_tax_district_changed_warning BOOLEAN;
1692:
1693: l_organization_id per_all_assignments_f.organization_id%TYPE;
1694: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
1695: l_location_id per_all_assignments_f.location_id%TYPE;
1696: l_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;
1697: l_gre_id NUMBER(15);
1698:
1699: l_final_process_date per_periods_of_service.final_process_date%TYPE;

Line 1696: l_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;

1692:
1693: l_organization_id per_all_assignments_f.organization_id%TYPE;
1694: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
1695: l_location_id per_all_assignments_f.location_id%TYPE;
1696: l_pay_basis_id per_all_assignments_f.pay_basis_id%TYPE;
1697: l_gre_id NUMBER(15);
1698:
1699: l_final_process_date per_periods_of_service.final_process_date%TYPE;
1700:

Line 1725: (p_table_name => 'PER_ALL_ASSIGNMENTS_F',

1721: IF v_ud_asg.last_upd_date = g_eot THEN
1722:
1723: hr_utility.set_location(l_proc, 20);
1724: l_assignment_id := hr_h2pi_map.get_to_id
1725: (p_table_name => 'PER_ALL_ASSIGNMENTS_F',
1726: p_from_id => v_ud_asg.assignment_id,
1727: p_report_error => TRUE);
1728:
1729: IF v_ud_asg.primary_flag = 'Y' THEN

Line 1819: (p_table_name => 'PER_ALL_ASSIGNMENTS_F',

1815: p_report_error => TRUE);
1816: v_ud_asg.segment1 := TO_CHAR(l_gre_id);
1817:
1818: l_assignment_id := hr_h2pi_map.get_to_id
1819: (p_table_name => 'PER_ALL_ASSIGNMENTS_F',
1820: p_from_id => v_ud_asg.assignment_id);
1821:
1822: IF l_assignment_id = -1 THEN
1823: hr_utility.set_location(l_proc, 80);

Line 1948: (p_table_name => 'PER_ALL_ASSIGNMENTS_F',

1944: );
1945:
1946: hr_utility.set_location(l_proc, 90);
1947: hr_h2pi_map.create_id_mapping
1948: (p_table_name => 'PER_ALL_ASSIGNMENTS_F',
1949: p_from_id => v_ud_asg.assignment_id,
1950: p_to_id => l_assignment_id);
1951: ELSE
1952:

Line 1989: FROM per_all_assignments_f asg

1985: l_records_same := FALSE;
1986:
1987: SELECT MAX(asg.effective_end_date)
1988: INTO l_max_eed
1989: FROM per_all_assignments_f asg
1990: WHERE asg.assignment_id = l_assignment_id;
1991:
1992: IF l_max_eed > v_ed_asg.effective_end_date THEN
1993: hr_utility.set_location(l_proc, 130);

Line 2521: (p_table_name => 'PER_ALL_ASSIGNMENTS_F',

2517: OPEN csr_ud_salary(p_pay_proposal_id);
2518: FETCH csr_ud_salary INTO v_ud_ppp;
2519:
2520: l_assignment_id := hr_h2pi_map.get_to_id
2521: (p_table_name => 'PER_ALL_ASSIGNMENTS_F',
2522: p_from_id => v_ud_ppp.assignment_id,
2523: p_report_error => TRUE);
2524:
2525: hr_utility.set_location(l_proc, 20);

Line 2702: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

2698:
2699: v_ud_ppm hr_h2pi_payment_methods%ROWTYPE;
2700: v_ed_ppm hr_h2pi_payment_methods_v%ROWTYPE;
2701:
2702: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
2703: l_personal_pay_method_id
2704: pay_personal_payment_methods_f.personal_payment_method_id%TYPE;
2705: l_org_pay_method_id pay_personal_payment_methods_f.org_payment_method_id%TYPE;
2706: l_ovn pay_personal_payment_methods_f.object_version_number%TYPE;

Line 2771: (p_table_name => 'PER_ALL_ASSIGNMENTS_F',

2767: ELSE
2768:
2769: hr_utility.set_location(l_proc, 70);
2770: l_assignment_id := hr_h2pi_map.get_to_id
2771: (p_table_name => 'PER_ALL_ASSIGNMENTS_F',
2772: p_from_id => v_ud_ppm.assignment_id,
2773: p_report_error => TRUE);
2774:
2775: l_org_pay_method_id := hr_h2pi_map.get_to_id

Line 3161: (p_table_name => 'PER_ALL_ASSIGNMENTS_F',

3157: ELSE
3158:
3159: hr_utility.set_location(l_proc, 40);
3160: l_assignment_id := hr_h2pi_map.get_to_id
3161: (p_table_name => 'PER_ALL_ASSIGNMENTS_F',
3162: p_from_id => v_ud_hca.assignment_id,
3163: p_report_error => TRUE);
3164:
3165: l_cost_allocation_id := hr_h2pi_map.get_to_id

Line 3431: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

3427:
3428: l_index NUMBER;
3429: a_input_value_id iv_array := iv_array(NULL,NULL,NULL,NULL,NULL,NULL,NULL,
3430: NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
3431: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
3432: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
3433: l_element_link_id pay_element_entries_f.element_link_id%TYPE;
3434: l_cost_allocation_keyflex_id
3435: pay_element_entries_f.cost_allocation_keyflex_id%TYPE;

Line 3536: (p_table_name => 'PER_ALL_ASSIGNMENTS_F',

3532: END LOOP;
3533:
3534: hr_utility.set_location(l_proc, 40);
3535: l_assignment_id := hr_h2pi_map.get_to_id
3536: (p_table_name => 'PER_ALL_ASSIGNMENTS_F',
3537: p_from_id => v_ud_ele.assignment_id,
3538: p_report_error => TRUE);
3539:
3540: l_element_entry_id := hr_h2pi_map.get_to_id

Line 3958: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

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

Line 4192: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

4188:
4189: v_ud_sta hr_h2pi_state_tax_rules%ROWTYPE;
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;

Line 4221: (p_table_name => 'PER_ALL_ASSIGNMENTS_F',

4217: FETCH csr_ud_state_tax_rule INTO v_ud_sta;
4218:
4219: hr_utility.set_location(l_proc, 20);
4220: l_assignment_id := hr_h2pi_map.get_to_id
4221: (p_table_name => 'PER_ALL_ASSIGNMENTS_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

Line 4473: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

4469:
4470: v_ud_cnt hr_h2pi_county_tax_rules%ROWTYPE;
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;

Line 4502: (p_table_name => 'PER_ALL_ASSIGNMENTS_F',

4498: FETCH csr_ud_county_tax_rule INTO v_ud_cnt;
4499:
4500: hr_utility.set_location(l_proc, 20);
4501: l_assignment_id := hr_h2pi_map.get_to_id
4502: (p_table_name => 'PER_ALL_ASSIGNMENTS_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

Line 4728: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

4724:
4725: v_ud_cty hr_h2pi_city_tax_rules%ROWTYPE;
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;

Line 4757: (p_table_name => 'PER_ALL_ASSIGNMENTS_F',

4753: FETCH csr_ud_city_tax_rule INTO v_ud_cty;
4754:
4755: hr_utility.set_location(l_proc, 20);
4756: l_assignment_id := hr_h2pi_map.get_to_id
4757: (p_table_name => 'PER_ALL_ASSIGNMENTS_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

Line 5144: l_ud_assignment_id per_all_assignments_f.assignment_id%TYPE;

5140: l_input_value_id1 pay_input_values_f.input_value_id%TYPE;
5141: l_input_value_id2 pay_input_values_f.input_value_id%TYPE;
5142: l_ud_input_value_id1 pay_input_values_f.input_value_id%TYPE;
5143: l_ud_input_value_id2 pay_input_values_f.input_value_id%TYPE;
5144: l_ud_assignment_id per_all_assignments_f.assignment_id%TYPE;
5145: l_person_id per_all_people_f.person_id%TYPE;
5146:
5147: l_effective_date DATE;
5148:

Line 5160: (p_table_name => 'PER_ALL_ASSIGNMENTS_F',

5156: FOR v_asg IN csr_ed_assignment(l_person_id) LOOP
5157:
5158: hr_utility.set_location(l_proc, 20);
5159: l_ud_assignment_id := hr_h2pi_map.get_from_id
5160: (p_table_name => 'PER_ALL_ASSIGNMENTS_F',
5161: p_to_id => v_asg.assignment_id,
5162: p_report_error => TRUE);
5163:
5164: SELECT MAX(effective_end_date)