APPS.HR_PROCESS_PERSON_SS dependencies on PER_PERIODS_OF_SERVICE

Line 158: ,per_periods_of_service pos

154: ,hc.comment_text
155: ,pos.adjusted_svc_date
156: FROM per_all_people_f per
157: ,hr_comments hc
158: ,per_periods_of_service pos
159: WHERE per.person_id = p_person_id
160: AND p_eff_date BETWEEN per.effective_start_date and per.effective_end_date
161: AND hc.comment_id (+) = per.comment_id
162: -- bug 2747159 : Making an outer join to the per_periods_of_service table.

Line 162: -- bug 2747159 : Making an outer join to the per_periods_of_service table.

158: ,per_periods_of_service pos
159: WHERE per.person_id = p_person_id
160: AND p_eff_date BETWEEN per.effective_start_date and per.effective_end_date
161: AND hc.comment_id (+) = per.comment_id
162: -- bug 2747159 : Making an outer join to the per_periods_of_service table.
163: AND per.person_id = pos.person_id(+)
164: and per.effective_start_date between pos.date_start(+)
165: and nvl(pos.actual_termination_date(+),per.effective_start_date);
166: -- bug #2679759 :getting the value of

Line 167: -- adj svc date from per_periods_of_service

163: AND per.person_id = pos.person_id(+)
164: and per.effective_start_date between pos.date_start(+)
165: and nvl(pos.actual_termination_date(+),per.effective_start_date);
166: -- bug #2679759 :getting the value of
167: -- adj svc date from per_periods_of_service
168:
169: --
170: CURSOR gc_get_current_applicant_flag
171: (p_person_id in number

Line 3410: hr_person_info_util_ss.create_ignore_df_validation('PER_PERIODS_OF_SERVICE');

3406: ignore validation using hr_dflex_utility.create_ignore_df_validation
3407: please refer to bug for further details.
3408: */
3409:
3410: hr_person_info_util_ss.create_ignore_df_validation('PER_PERIODS_OF_SERVICE');
3411:
3412:
3413: hr_person_api.update_person (
3414: p_validate => false

Line 5423: hr_person_info_util_ss.create_ignore_df_validation('PER_PERIODS_OF_SERVICE');

5419: end if;
5420:
5421: -- Fix bug :2091186
5422:
5423: hr_person_info_util_ss.create_ignore_df_validation('PER_PERIODS_OF_SERVICE');
5424:
5425: ---------------------------------------------------------------------------
5426: -- Bug 1937643 Fix Begins - 08/04/2002
5427: -- With the PTU model, the per_all_people_f.person_type_id stores only the