SELECT p.full_name , w.selected_person_id , w.owning_person_id , p.effective_start_date , p.effective_end_date from hr_working_person_lists w , per_people_f p where p.person_id = w.selected_person_id
View Text - HTML Formatted
SELECT P.FULL_NAME , W.SELECTED_PERSON_ID , W.OWNING_PERSON_ID , P.EFFECTIVE_START_DATE , P.EFFECTIVE_END_DATE FROM HR_WORKING_PERSON_LISTS W , PER_PEOPLE_F P WHERE P.PERSON_ID = W.SELECTED_PERSON_ID