APPS.BEN_ELIG_QUAL_TITL_PRTE_X
[Home] [Help]
| Product: | BEN - Advanced Benefits |
|---|---|
| Description: | |
| Implementation/DBA Data: |
APPS.BEN_ELIG_QUAL_TITL_PRTE_X
|
SELECT ELIG_QUAL_TITL_PRTE_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID
, ELIGY_PRFL_ID
, EXCLD_FLAG
, TITLE
, QUALIFICATION_TYPE_ID
, EQT_ATTRIBUTE_CATEGORY
, EQT_ATTRIBUTE1
, EQT_ATTRIBUTE2
, EQT_ATTRIBUTE3
, EQT_ATTRIBUTE4
, EQT_ATTRIBUTE5
, EQT_ATTRIBUTE6
, EQT_ATTRIBUTE7
, EQT_ATTRIBUTE8
, EQT_ATTRIBUTE9
, EQT_ATTRIBUTE10
, EQT_ATTRIBUTE11
, EQT_ATTRIBUTE12
, EQT_ATTRIBUTE13
, EQT_ATTRIBUTE14
, EQT_ATTRIBUTE15
, EQT_ATTRIBUTE16
, EQT_ATTRIBUTE17
, EQT_ATTRIBUTE18
, EQT_ATTRIBUTE19
, EQT_ATTRIBUTE20
, EQT_ATTRIBUTE21
, EQT_ATTRIBUTE22
, EQT_ATTRIBUTE23
, EQT_ATTRIBUTE24
, EQT_ATTRIBUTE25
, EQT_ATTRIBUTE26
, EQT_ATTRIBUTE27
, EQT_ATTRIBUTE28
, EQT_ATTRIBUTE29
, EQT_ATTRIBUTE30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, OBJECT_VERSION_NUMBER
FROM BEN_ELIG_QUAL_TITL_PRTE_F EQT
WHERE TRUNC(SYSDATE) BETWEEN EQT.EFFECTIVE_START_DATE
AND EQT.EFFECTIVE_END_DATE