APPS.PER_ASSIGNMENTS_F2_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 289: from per_periods_of_service p

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

Line 627: from per_periods_of_service pos

623: -- perform the referential integrity checks.
624: --
625: cursor pd_os is
626: select 1
627: from per_periods_of_service pos
628: where pos.period_of_service_id = P_PD_OS_ID
629: and exists (
630: select null
631: from per_all_assignments_f a

Line 643: from per_periods_of_service pos

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