DBA Data[Home] [Help]

VIEW: APPS.HR_WORKING_PERSON_LISTS_V

Source

View Text - Preformatted

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