DBA Data[Home] [Help]

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