VIEW: APPS.PAY_JP_DEF_USER_V

Source

View Text - Preformatted

SELECT usr.user_id, nvl(per.full_name, usr.user_name), usr.email_address, usr.LAST_UPDATE_DATE, usr.LAST_UPDATED_BY, usr.CREATION_DATE, usr.CREATED_BY, usr.LAST_UPDATE_LOGIN from per_all_people_f per, fnd_user usr where per.person_id(+) = usr.employee_id and trunc(sysdate) between per.effective_start_date(+) and per.effective_end_date(+)

View Text - HTML Formatted

SELECT USR.USER_ID
, NVL(PER.FULL_NAME
, USR.USER_NAME)
, USR.EMAIL_ADDRESS
, USR.LAST_UPDATE_DATE
, USR.LAST_UPDATED_BY
, USR.CREATION_DATE
, USR.CREATED_BY
, USR.LAST_UPDATE_LOGIN
FROM PER_ALL_PEOPLE_F PER
, FND_USER USR
WHERE PER.PERSON_ID(+) = USR.EMPLOYEE_ID
AND TRUNC(SYSDATE) BETWEEN PER.EFFECTIVE_START_DATE(+)
AND PER.EFFECTIVE_END_DATE(+)