APPS.HR_PERF_MGMT_PLAN_INTERNAL dependencies on PER_PERIODS_OF_SERVICE

Line 277: FROM per_all_people_f ppf, per_periods_of_service pps

273: SELECT 'Y'
274: FROM DUAL
275: WHERE EXISTS (
276: SELECT 'x'
277: FROM per_all_people_f ppf, per_periods_of_service pps
278: WHERE ppf.person_id = p_supervisor_id
279: AND TRUNC (SYSDATE) BETWEEN ppf.effective_start_date AND ppf.effective_end_date
280: AND ppf.person_id = pps.person_id
281: AND TRUNC (SYSDATE) BETWEEN pps.date_start AND NVL (pps.actual_termination_date, TRUNC (SYSDATE)));

Line 290: FROM per_all_assignments_f paaf, per_periods_of_service pps

286: SELECT 'Y'
287: FROM DUAL
288: WHERE EXISTS (
289: SELECT 'x'
290: FROM per_all_assignments_f paaf, per_periods_of_service pps
291: WHERE paaf.assignment_id = p_supervisor_asg_id
292: AND TRUNC (SYSDATE) BETWEEN paaf.effective_start_date AND paaf.effective_end_date
293: AND paaf.period_of_service_id = pps.period_of_service_id
294: AND TRUNC (SYSDATE) BETWEEN pps.date_start AND NVL (pps.actual_termination_date, TRUNC (SYSDATE)));