APPS.HR_FULL_SYNC_MESSAGES dependencies on PER_PERIODS_OF_PLACEMENT

Line 547: FROM per_periods_of_placement ppp

543: ))
544: OR ( ppf.CURRENT_NPW_FLAG = 'Y'
545: OR ppf.person_id in -- modified for bug6873563
546: (SELECT nvl(ppp.person_id , -100)
547: FROM per_periods_of_placement ppp
548: WHERE ppp.person_id = ppf.person_id
549: AND ppp.business_group_id = ppf.business_group_id
550: and ACTUAL_TERMINATION_DATE is not null
551: )))