[Home] [Help]
745: -- period of service.
746: --
747: CURSOR csr_get_term_dates IS
748: SELECT actual_termination_date
749: ,NVL(final_process_date, hr_api.g_eot)
750: FROM per_periods_of_service
751: WHERE period_of_service_id = p_period_of_service_id
752: UNION
753: SELECT pdp.actual_termination_date
750: FROM per_periods_of_service
751: WHERE period_of_service_id = p_period_of_service_id
752: UNION
753: SELECT pdp.actual_termination_date
754: ,NVL(pdp.final_process_date, hr_api.g_eot)
755: FROM per_periods_of_placement pdp
756: WHERE pdp.person_id = l_person_id
757: AND pdp.date_start = l_pdp_date_start;
758:
2155: -- Get the termination dates for the period of placement and
2156: -- period of service.
2157: --
2158: CURSOR csr_get_term_dates IS
2159: SELECT NVL(actual_termination_date, hr_api.g_eot)
2160: ,NVL(final_process_date, hr_api.g_eot)
2161: FROM per_periods_of_service
2162: WHERE period_of_service_id = p_period_of_service_id
2163: UNION
2156: -- period of service.
2157: --
2158: CURSOR csr_get_term_dates IS
2159: SELECT NVL(actual_termination_date, hr_api.g_eot)
2160: ,NVL(final_process_date, hr_api.g_eot)
2161: FROM per_periods_of_service
2162: WHERE period_of_service_id = p_period_of_service_id
2163: UNION
2164: SELECT NVL(pdp.actual_termination_date, hr_api.g_eot)
2160: ,NVL(final_process_date, hr_api.g_eot)
2161: FROM per_periods_of_service
2162: WHERE period_of_service_id = p_period_of_service_id
2163: UNION
2164: SELECT NVL(pdp.actual_termination_date, hr_api.g_eot)
2165: ,NVL(pdp.final_process_date, hr_api.g_eot)
2166: FROM per_periods_of_placement pdp
2167: WHERE pdp.person_id = l_person_id
2168: AND pdp.date_start = l_pdp_date_start;
2161: FROM per_periods_of_service
2162: WHERE period_of_service_id = p_period_of_service_id
2163: UNION
2164: SELECT NVL(pdp.actual_termination_date, hr_api.g_eot)
2165: ,NVL(pdp.final_process_date, hr_api.g_eot)
2166: FROM per_periods_of_placement pdp
2167: WHERE pdp.person_id = l_person_id
2168: AND pdp.date_start = l_pdp_date_start;
2169:
3050: --
3051: -- Calling proces = 'POST_UPDATE' then a min step has to be created for the new grade scale
3052: --
3053: if p_calling_proc = 'POST_UPDATE' and
3054: p_datetrack_mode <> hr_api.g_update_override then -- Bug 3335915
3055:
3056: --
3057: -- get the placement_id and object_version_number for
3058: -- the current record as of the effective date
3999: --
4000: hr_rate_values_api.delete_rate_value
4001: (p_validate => FALSE
4002: ,p_grade_rule_id => crec_current_asg_rates.grade_rule_id
4003: ,p_datetrack_mode => hr_api.g_delete
4004: ,p_effective_date => p_new_end_date
4005: ,p_object_version_number => crec_current_asg_rates.object_version_number
4006: ,p_effective_start_date => l_effective_start_date
4007: ,p_effective_end_date => l_effective_end_date);
4018: --
4019: hr_rate_values_api.delete_rate_value
4020: (p_validate => FALSE
4021: ,p_grade_rule_id => crec_future_asg_rates.grade_rule_id
4022: ,p_datetrack_mode => hr_api.g_zap
4023: ,p_effective_date => crec_future_asg_rates.effective_start_date
4024: ,p_object_version_number => crec_future_asg_rates.object_version_number
4025: ,p_effective_start_date => l_effective_start_date
4026: ,p_effective_end_date => l_effective_end_date);
4470: SELECT p.date_start date_start, p.period_of_service_id
4471: FROM per_periods_of_service p
4472: WHERE p.person_id = to_number(p_person_id)
4473: AND fnd_date.canonical_to_date(p_new_date) BETWEEN
4474: p.date_start AND NVL(p.final_process_date, hr_api.g_eot)
4475: UNION
4476: SELECT pdp.date_start date_start, pdp.period_of_placement_id
4477: FROM per_periods_of_placement pdp
4478: WHERE pdp.person_id = to_number(p_person_id)
4476: SELECT pdp.date_start date_start, pdp.period_of_placement_id
4477: FROM per_periods_of_placement pdp
4478: WHERE pdp.person_id = to_number(p_person_id)
4479: AND fnd_date.canonical_to_date(p_new_date) BETWEEN
4480: pdp.date_start AND NVL(pdp.final_process_date, hr_api.g_eot)
4481: ORDER BY date_start DESC;
4482:
4483: BEGIN
4484: