[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: |
APPS.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 |