DBA Data[Home] [Help]

APPS.HR_HEAD_COUNT_SUMMARY dependencies on PER_PERIODS_OF_PLACEMENT

Line 294: from per_periods_of_placement pop

290: between P_DATE_FROM
291: and P_DATE_TO)
292: UNION
293: select paf.job_id
294: from per_periods_of_placement pop
295: ,per_all_assignments_f paf
296: where pop.date_start <= P_DATE_FROM
297: and pop.actual_termination_date is not null
298: and pop.actual_termination_date between P_DATE_FROM