FND Design Data [Home] [Help]

View: HR_FNDSCAUS_PERSON_V

Product: PER - Human Resources
Description: To support person lov in aol define user form (FNDSCAUS)
Implementation/DBA Data: ViewAPPS.HR_FNDSCAUS_PERSON_V
View Text

SELECT P.FULL_NAME
, P.PERSON_ID
FROM PER_ALL_PEOPLE_F P
WHERE TRUNC(SYSDATE) BETWEEN P.EFFECTIVE_START_DATE
AND P.EFFECTIVE_END_DATE UNION SELECT P.FULL_NAME
, P.PERSON_ID
FROM PER_ALL_PEOPLE_F P
WHERE P.EFFECTIVE_START_DATE = (SELECT MIN(P2.EFFECTIVE_START_DATE)
FROM PER_ALL_PEOPLE_F P2
WHERE P2.PERSON_ID=P.PERSON_ID)
AND P.EFFECTIVE_START_DATE > TRUNC(SYSDATE)

Columns

Name
PERSON_NAME
PERSON_ID