DBA Data[Home] [Help]

APPS.PER_IN_PERSON_TERM_LEG_HOOK dependencies on PER_PEOPLE_F

Line 459: ,per_people_f ppf

455: SELECT pos.actual_termination_date
456: ,ppf.business_group_id
457: FROM per_periods_of_service pos
458: ,per_assignments_f paf
459: ,per_people_f ppf
460: WHERE pos.period_of_service_id = p_period_of_service_id
461: AND pos.period_of_service_id = paf.period_of_service_id
462: AND paf.person_id = ppf.person_id
463: AND p_effective_date BETWEEN ppf.effective_start_date