View: GHR_PEOPLE_V

Product:	GHR - US Federal Human Resources
Description:	This view is based on table PER_PEOPLE_F
Implementation/DBA Data:	APPS.GHR_PEOPLE_V

View Text

SELECT DISTINCT PER.PERSON_ID PERSON_ID
, FULL_NAME
, NATIONAL_IDENTIFIER
, NATIONALITY
FROM PER_PEOPLE_F PER
WHERE PER.EFFECTIVE_START_DATE = (SELECT MAX(EFFECTIVE_START_DATE)
FROM PER_PEOPLE_F PPF
WHERE PPF.PERSON_ID = PER.PERSON_ID)
AND EXISTS (SELECT 1
FROM GHR_PA_REQUESTS PAR
WHERE PAR.PERSON_ID = PER.PERSON_ID)

Columns