Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_PL_PCP_V |
SELECT PLF.NAME
, PCP.PL_PCP_ID
, PCP.PL_ID
, PCP.BUSINESS_GROUP_ID
, PCP.PCP_STRT_DT_CD
, PCP.PCP_DSGN_CD
, PCP.PCP_DPNT_DSGN_CD
, PCP.PCP_RPSTRY_FLAG
, PCP.PCP_CAN_KEEP_FLAG
, PCP.PCP_RADIUS
, PCP.PCP_RADIUS_UOM
, PCP.PCP_RADIUS_WARN_FLAG
, PCP.PCP_NUM_CHGS
, PCP.PCP_NUM_CHGS_UOM
, PCP.PCP_ATTRIBUTE_CATEGORY
, PCP.PCP_ATTRIBUTE1
, PCP.PCP_ATTRIBUTE2
, PCP.PCP_ATTRIBUTE3
, PCP.PCP_ATTRIBUTE4
, PCP.PCP_ATTRIBUTE5
, PCP.PCP_ATTRIBUTE6
, PCP.PCP_ATTRIBUTE7
, PCP.PCP_ATTRIBUTE8
, PCP.PCP_ATTRIBUTE9
, PCP.PCP_ATTRIBUTE10
, PCP.PCP_ATTRIBUTE11
, PCP.PCP_ATTRIBUTE12
, PCP.PCP_ATTRIBUTE13
, PCP.PCP_ATTRIBUTE14
, PCP.PCP_ATTRIBUTE15
, PCP.PCP_ATTRIBUTE16
, PCP.PCP_ATTRIBUTE17
, PCP.PCP_ATTRIBUTE18
, PCP.PCP_ATTRIBUTE19
, PCP.PCP_ATTRIBUTE20
, PCP.PCP_ATTRIBUTE21
, PCP.PCP_ATTRIBUTE22
, PCP.PCP_ATTRIBUTE23
, PCP.PCP_ATTRIBUTE24
, PCP.PCP_ATTRIBUTE25
, PCP.PCP_ATTRIBUTE26
, PCP.PCP_ATTRIBUTE27
, PCP.PCP_ATTRIBUTE28
, PCP.PCP_ATTRIBUTE29
, PCP.PCP_ATTRIBUTE30
, PCP.LAST_UPDATE_DATE
, PCP.LAST_UPDATED_BY
, PCP.LAST_UPDATE_LOGIN
, PCP.CREATED_BY
, PCP.CREATION_DATE
, PCP.OBJECT_VERSION_NUMBER
FROM BEN_PL_PCP PCP
, BEN_PL_F PLF
, FND_SESSIONS SE
WHERE PCP.PL_ID = PLF.PL_ID
AND SE.SESSION_ID=USERENV('SESSIONID')
AND SE.EFFECTIVE_DATE BETWEEN PLF.EFFECTIVE_START_DATE
AND PLF.EFFECTIVE_END_DATE