Product: | BEN - Advanced Benefits |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BEN_PL_TYP_X |
SELECT PTP.ROWID ROW_ID
, PTP.PL_TYP_ID
, PTP.EFFECTIVE_START_DATE
, PTP.EFFECTIVE_END_DATE
, PTP.NAME
, PTP.MX_ENRL_ALWD_NUM
, PTP.MN_ENRL_RQD_NUM
, PTP.PL_TYP_STAT_CD
, PTP.IVR_IDENT
, PTP.NO_MX_ENRL_NUM_DFND_FLAG
, PTP.NO_MN_ENRL_NUM_DFND_FLAG
, PTP.OPT_TYP_CD
, PTP.BUSINESS_GROUP_ID
, PTP.PTP_ATTRIBUTE_CATEGORY
, PTP.PTP_ATTRIBUTE1
, PTP.PTP_ATTRIBUTE2
, PTP.PTP_ATTRIBUTE3
, PTP.PTP_ATTRIBUTE4
, PTP.PTP_ATTRIBUTE5
, PTP.PTP_ATTRIBUTE6
, PTP.PTP_ATTRIBUTE7
, PTP.PTP_ATTRIBUTE8
, PTP.PTP_ATTRIBUTE9
, PTP.PTP_ATTRIBUTE10
, PTP.PTP_ATTRIBUTE11
, PTP.PTP_ATTRIBUTE12
, PTP.PTP_ATTRIBUTE13
, PTP.PTP_ATTRIBUTE14
, PTP.PTP_ATTRIBUTE15
, PTP.PTP_ATTRIBUTE16
, PTP.PTP_ATTRIBUTE17
, PTP.PTP_ATTRIBUTE18
, PTP.PTP_ATTRIBUTE19
, PTP.PTP_ATTRIBUTE20
, PTP.PTP_ATTRIBUTE21
, PTP.PTP_ATTRIBUTE22
, PTP.PTP_ATTRIBUTE23
, PTP.PTP_ATTRIBUTE24
, PTP.PTP_ATTRIBUTE25
, PTP.PTP_ATTRIBUTE26
, PTP.PTP_ATTRIBUTE27
, PTP.PTP_ATTRIBUTE28
, PTP.PTP_ATTRIBUTE29
, PTP.PTP_ATTRIBUTE30
, PTP.LAST_UPDATE_DATE
, PTP.LAST_UPDATED_BY
, PTP.LAST_UPDATE_LOGIN
, PTP.CREATED_BY
, PTP.CREATION_DATE
, PTP.OBJECT_VERSION_NUMBER
, PTP.OPT_DSPLY_FMT_CD
, PTP.COMP_TYP_CD
, PTP.SHORT_NAME
, PTP.SHORT_CODE
, PTP.LEGISLATION_CODE
, PTP.LEGISLATION_SUBGROUP
FROM BEN_PL_TYP_F PTP
WHERE TRUNC(SYSDATE) BETWEEN PTP.EFFECTIVE_START_DATE
AND PTP.EFFECTIVE_END_DATE