APPS.HR_HEAD_COUNT_SUMMARY dependencies on PER_PERIODS_OF_SERVICE
Line 276: from per_periods_of_service pos
272: , P_BUSINESS_GROUP_ID NUMBER
273: )
274: is
275: select paf.job_id 276: from per_periods_of_service pos 277: ,per_all_assignments_f paf
278: where pos.date_start <= P_DATE_FROM
279: and pos.actual_termination_date is not null
280: and pos.actual_termination_date between P_DATE_FROM and P_DATE_TO