VIEW: APPS.BEN_PL_TYP_X

Source

View Text - Preformatted

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

View Text - HTML Formatted

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