View: PAY_JP_ISDF_USER_V

Product:	PAY - Payroll
Description:	This view is used for Japanese localization only.
Implementation/DBA Data:	APPS.PAY_JP_ISDF_USER_V

View Text

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(+)

Columns