VIEW: APPS.PAY_JP_ISDF_USER_V

Source

View Text - Preformatted

SELECT fu.user_id, nvl(pp.full_name, fu.user_name), fu.email_address, fu.last_update_login, fu.last_updated_by, fu.last_update_date, fu.created_by, fu.creation_date from fnd_user fu, per_all_people_f pp where pp.person_id (+) = fu.employee_id and trunc(sysdate) between pp.effective_start_date(+) and pp.effective_end_date(+)

View Text - HTML Formatted

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