View: PAY_JP_DEF_USER_V

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

View Text

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

Columns