Product: | BEN - Advanced Benefits |
---|---|
Description: | |
Implementation/DBA Data: | APPS.BEN_POPL_ACTN_TYP |
SELECT PAT.POPL_ACTN_TYP_ID
, PAT.EFFECTIVE_START_DATE
, PAT.EFFECTIVE_END_DATE
, PAT.ACTN_TYP_DUE_DT_CD
, PAT.ACTN_TYP_DUE_DT_RL
, PAT.ACTN_TYP_ID
, PAT.PGM_ID
, PAT.PL_ID
, PAT.BUSINESS_GROUP_ID
, PAT.PAT_ATTRIBUTE_CATEGORY
, PAT.PAT_ATTRIBUTE1
, PAT.PAT_ATTRIBUTE2
, PAT.PAT_ATTRIBUTE3
, PAT.PAT_ATTRIBUTE4
, PAT.PAT_ATTRIBUTE5
, PAT.PAT_ATTRIBUTE6
, PAT.PAT_ATTRIBUTE7
, PAT.PAT_ATTRIBUTE8
, PAT.PAT_ATTRIBUTE9
, PAT.PAT_ATTRIBUTE10
, PAT.PAT_ATTRIBUTE11
, PAT.PAT_ATTRIBUTE12
, PAT.PAT_ATTRIBUTE13
, PAT.PAT_ATTRIBUTE14
, PAT.PAT_ATTRIBUTE15
, PAT.PAT_ATTRIBUTE16
, PAT.PAT_ATTRIBUTE17
, PAT.PAT_ATTRIBUTE18
, PAT.PAT_ATTRIBUTE19
, PAT.PAT_ATTRIBUTE20
, PAT.PAT_ATTRIBUTE21
, PAT.PAT_ATTRIBUTE22
, PAT.PAT_ATTRIBUTE23
, PAT.PAT_ATTRIBUTE24
, PAT.PAT_ATTRIBUTE25
, PAT.PAT_ATTRIBUTE26
, PAT.PAT_ATTRIBUTE27
, PAT.PAT_ATTRIBUTE28
, PAT.PAT_ATTRIBUTE29
, PAT.PAT_ATTRIBUTE30
, PAT.LAST_UPDATE_DATE
, PAT.LAST_UPDATED_BY
, PAT.LAST_UPDATE_LOGIN
, PAT.CREATED_BY
, PAT.CREATION_DATE
, PAT.OBJECT_VERSION_NUMBER
FROM BEN_POPL_ACTN_TYP_F PAT
WHERE PAT.EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND PAT.EFFECTIVE_END_DATE >= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))