FND Design Data [Home] [Help]

View: HR_FNDSCAUS_PERSON_LOV_V

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

SELECT P.FULL_NAME
, DECODE(P.CURRENT_EMPLOYEE_FLAG
, 'Y'
, '*'
, 'Y'
, '*'
, '') CURRENT_EMPLOYEE_FLAG
, H.NAME
, P.EMPLOYEE_NUMBER
, P.EMAIL_ADDRESS
, P.PERSON_ID
FROM PER_ALL_PEOPLE_F P
, PER_BUSINESS_GROUPS H
WHERE TRUNC(SYSDATE) BETWEEN P.EFFECTIVE_START_DATE
AND P.EFFECTIVE_END_DATE
AND P.BUSINESS_GROUP_ID=H.BUSINESS_GROUP_ID UNION SELECT P.FULL_NAME
, DECODE(P.CURRENT_EMPLOYEE_FLAG
, 'Y'
, '*'
, 'Y'
, '*'
, '') CURRENT_EMPLOYEE_FLAG
, H.NAME
, P.EMPLOYEE_NUMBER
, P.EMAIL_ADDRESS
, P.PERSON_ID
FROM PER_ALL_PEOPLE_F P
, PER_BUSINESS_GROUPS H
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)
AND P.BUSINESS_GROUP_ID = H.BUSINESS_GROUP_ID

Columns

Name
FULL_NAME
CURRENT_EMPLOYEE_FLAG
BUSINESS_GROUP_NAME
EMPLOYEE_NUMBER
EMAIL_ADDRESS
PERSON_ID