View: BEN_PER_DLVRY_MTHD_X

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

View Text

SELECT PDM.PER_DLVRY_MTHD_ID
, PDM.EFFECTIVE_START_DATE
, PDM.EFFECTIVE_END_DATE
, PDM.BUSINESS_GROUP_ID
, PDM.PERSON_ID
, PDM.PFD_FLAG
, PDM.CM_DLVRY_MTHD_CD
, PDM.PDM_ATTRIBUTE_CATEGORY
, PDM.PDM_ATTRIBUTE1
, PDM.PDM_ATTRIBUTE2
, PDM.PDM_ATTRIBUTE3
, PDM.PDM_ATTRIBUTE4
, PDM.PDM_ATTRIBUTE5
, PDM.PDM_ATTRIBUTE6
, PDM.PDM_ATTRIBUTE7
, PDM.PDM_ATTRIBUTE8
, PDM.PDM_ATTRIBUTE9
, PDM.PDM_ATTRIBUTE10
, PDM.PDM_ATTRIBUTE11
, PDM.PDM_ATTRIBUTE12
, PDM.PDM_ATTRIBUTE13
, PDM.PDM_ATTRIBUTE14
, PDM.PDM_ATTRIBUTE15
, PDM.PDM_ATTRIBUTE16
, PDM.PDM_ATTRIBUTE17
, PDM.PDM_ATTRIBUTE18
, PDM.PDM_ATTRIBUTE19
, PDM.PDM_ATTRIBUTE20
, PDM.PDM_ATTRIBUTE21
, PDM.PDM_ATTRIBUTE22
, PDM.PDM_ATTRIBUTE23
, PDM.PDM_ATTRIBUTE24
, PDM.PDM_ATTRIBUTE25
, PDM.PDM_ATTRIBUTE26
, PDM.PDM_ATTRIBUTE27
, PDM.PDM_ATTRIBUTE28
, PDM.PDM_ATTRIBUTE29
, PDM.PDM_ATTRIBUTE30
, PDM.LAST_UPDATE_DATE
, PDM.LAST_UPDATED_BY
, PDM.LAST_UPDATE_LOGIN
, PDM.CREATED_BY
, PDM.CREATION_DATE
, PDM.OBJECT_VERSION_NUMBER
FROM BEN_PER_DLVRY_MTHD_F PDM
WHERE TRUNC(SYSDATE) BETWEEN PDM.EFFECTIVE_START_DATE
AND PDM.EFFECTIVE_END_DATE

Columns