160: ,hc.comment_text
161: ,pos.adjusted_svc_date
162: FROM per_all_people_f per
163: ,hr_comments hc
164: ,per_periods_of_service pos
165: WHERE per.person_id = p_person_id
166: AND p_eff_date BETWEEN per.effective_start_date and per.effective_end_date
167: AND hc.comment_id (+) = per.comment_id
168: -- bug 2747159 : Making an outer join to the per_periods_of_service table.
164: ,per_periods_of_service pos
165: WHERE per.person_id = p_person_id
166: AND p_eff_date BETWEEN per.effective_start_date and per.effective_end_date
167: AND hc.comment_id (+) = per.comment_id
168: -- bug 2747159 : Making an outer join to the per_periods_of_service table.
169: AND per.person_id = pos.person_id(+)
170: and per.effective_start_date between pos.date_start(+)
171: and nvl(pos.actual_termination_date(+),per.effective_start_date);
172: -- bug #2679759 :getting the value of
169: AND per.person_id = pos.person_id(+)
170: and per.effective_start_date between pos.date_start(+)
171: and nvl(pos.actual_termination_date(+),per.effective_start_date);
172: -- bug #2679759 :getting the value of
173: -- adj svc date from per_periods_of_service
174:
175: --
176: CURSOR gc_get_current_applicant_flag
177: (p_person_id in number
3782: ignore validation using hr_dflex_utility.create_ignore_df_validation
3783: please refer to bug for further details.
3784: */
3785:
3786: hr_person_info_util_ss.create_ignore_df_validation('PER_PERIODS_OF_SERVICE');
3787:
3788:
3789: hr_person_api.update_person (
3790: p_validate => false
5976: end if;
5977: end if;
5978: -- Fix bug :2091186
5979:
5980: hr_person_info_util_ss.create_ignore_df_validation('PER_PERIODS_OF_SERVICE');
5981:
5982: ---------------------------------------------------------------------------
5983: -- Bug 1937643 Fix Begins - 08/04/2002
5984: -- With the PTU model, the per_all_people_f.person_type_id stores only the