APPS.HR_FULL_SYNC_MESSAGES dependencies on PER_PERIODS_OF_PLACEMENT

Line 546: FROM per_periods_of_placement ppp

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