View: BEN_PER_PIN_D

Product:	BEN - Advanced Benefits
Description:	- Retrofitted
Implementation/DBA Data:	APPS.BEN_PER_PIN_D

View Text

SELECT PPN.ROWID ROW_ID
, PPN.PER_PIN_ID
, PPN.EFFECTIVE_START_DATE
, PPN.EFFECTIVE_END_DATE
, PPN.PSWD_NAME
, PER_PIN_PRPS.MEANING
, PPN.LAST_UPDATE_DATE
, FUSER.LAST_UPDATED_BY
FROM BEN_PER_PIN_F PPN
, FND_USER FUSER
, HR_LOOKUPS PER_PIN_PRPS
WHERE FUSER.USER_ID (+)= PPN .LAST_UPDATED_BY
AND PER_PIN_PRPS.LOOKUP_CODE (+)= PPN .PER_PIN_PRPS_CD
AND PER_PIN_PRPS.LOOKUP_TYPE (+)= 'BEN_PIN_PRPS'

Columns