APPS.HR_TERMINATION_SS dependencies on PER_PERIODS_OF_PLACEMENT

Line 248: ,per_periods_of_placement ppop

244: UNION -- CWK Phase III Changes.
245: SELECT ppf.person_id
246: FROM per_all_people_f ppf -- Bug 2130066 fix
247: ,per_all_assignments_f paf
248: ,per_periods_of_placement ppop
249: WHERE paf.supervisor_id = l_number_value
250: AND paf.person_id = ppf.person_id
251: AND ppf.person_id = ppop.person_id
252: AND ppf.current_npw_flag = 'Y'