APPS.PER_ASSIGNMENTS_F2_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 293: from per_periods_of_service p

289: and vg.job_id is not null;
290: --
291: cursor get_pd_of_ser is
292: select p.date_start date_start, p.period_of_service_id
293: from per_periods_of_service p
294: where p.person_id = P_PERSON_ID
295: and P_SESS_DATE between
296: p.date_start and nvl(p.final_process_date, P_END_OF_TIME)
297: union

Line 631: from per_periods_of_service pos

627: -- perform the referential integrity checks.
628: --
629: cursor pd_os is
630: select 1
631: from per_periods_of_service pos
632: where pos.period_of_service_id = P_PD_OS_ID
633: and exists (
634: select null
635: from per_all_assignments_f a

Line 647: from per_periods_of_service pos

643: and a.person_id = P_PER_ID
644: and a.assignment_type = 'E'
645: and exists (
646: select null
647: from per_periods_of_service pos
648: where pos.period_of_service_id = P_PD_OS_ID
649: and pos.date_start = a.effective_start_date);
650: --
651: l_proc varchar2(15) := 'real_del_checks';