VIEW: APPS.BEN_PER_PIN_D

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'