eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: PER_COBRA_COVERAGE_BENEFITS_V

Product:	PER - Human Resources
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PER_COBRA_COVERAGE_BENEFITS_V

View Text

SELECT CCB.ROWID ROW_ID
, CCB.COBRA_COVERAGE_BENEFIT_ID COBRA_COVERAGE_BENEFIT_ID
, BC2.BENEFIT_CLASSIFICATION_NAME BENEFIT_CLASSIFICATION_NAME
, ETTL.ELEMENT_NAME ELEMENT_NAME
, CCB.COVERAGE_TYPE COVERAGE_TYPE
, L1.MEANING COVERAGE_TYPE_MEANING
, CCB.COVERAGE_AMOUNT COVERAGE_AMOUNT
, CCB.EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, CCB.EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, CCB.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID
, CCB.COBRA_COVERAGE_ENROLLMENT_ID COBRA_COVERAGE_ENROLLMENT_ID
, CCB.ELEMENT_TYPE_ID ELEMENT_TYPE_ID
, CCB.ACCEPT_REJECT_FLAG ACCEPT_REJECT_FLAG
, CCB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CCB.ATTRIBUTE1 ATTRIBUTE1
, CCB.ATTRIBUTE2 ATTRIBUTE2
, CCB.ATTRIBUTE3 ATTRIBUTE3
, CCB.ATTRIBUTE4 ATTRIBUTE4
, CCB.ATTRIBUTE5 ATTRIBUTE5
, CCB.ATTRIBUTE6 ATTRIBUTE6
, CCB.ATTRIBUTE7 ATTRIBUTE7
, CCB.ATTRIBUTE8 ATTRIBUTE8
, CCB.ATTRIBUTE9 ATTRIBUTE9
, CCB.ATTRIBUTE10 ATTRIBUTE10
, CCB.ATTRIBUTE11 ATTRIBUTE11
, CCB.ATTRIBUTE12 ATTRIBUTE12
, CCB.ATTRIBUTE13 ATTRIBUTE13
, CCB.ATTRIBUTE14 ATTRIBUTE14
, CCB.ATTRIBUTE15 ATTRIBUTE15
, CCB.ATTRIBUTE16 ATTRIBUTE16
, CCB.ATTRIBUTE17 ATTRIBUTE17
, CCB.ATTRIBUTE18 ATTRIBUTE18
, CCB.ATTRIBUTE19 ATTRIBUTE19
, CCB.ATTRIBUTE20 ATTRIBUTE20
, CCB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CCB.LAST_UPDATED_BY LAST_UPDATED_BY
, CCB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CCB.CREATED_BY CREATED_BY
, CCB.CREATION_DATE CREATION_DATE
FROM HR_LOOKUPS L1
, BEN_BENEFIT_CLASSIFICATIONS BC2
, PAY_ELEMENT_TYPES_F ET
, PAY_ELEMENT_TYPES_F_TL ETTL
, PER_COBRA_COVERAGE_BENEFITS_F CCB
, FND_SESSIONS S
WHERE BC2.BENEFIT_CLASSIFICATION_ID = ET.BENEFIT_CLASSIFICATION_ID
AND ET.ELEMENT_TYPE_ID = CCB.ELEMENT_TYPE_ID
AND ET.ELEMENT_TYPE_ID = ETTL.ELEMENT_TYPE_ID
AND L1.LOOKUP_TYPE = 'US_BENEFIT_COVERAGE'
AND L1.LOOKUP_CODE = CCB.COVERAGE_TYPE
AND S.EFFECTIVE_DATE BETWEEN ET.EFFECTIVE_START_DATE
AND ET.EFFECTIVE_END_DATE
AND S.EFFECTIVE_DATE BETWEEN CCB.EFFECTIVE_START_DATE
AND CCB.EFFECTIVE_END_DATE
AND S.SESSION_ID = USERENV('SESSIONID')
AND ETTL.LANGUAGE = USERENV('LANG')

Columns

Name
ROW_ID
COBRA_COVERAGE_BENEFIT_ID
BENEFIT_CLASSIFICATION_NAME
ELEMENT_NAME
COVERAGE_TYPE
COVERAGE_TYPE_MEANING
COVERAGE_AMOUNT
EFFECTIVE_START_DATE
EFFECTIVE_END_DATE
BUSINESS_GROUP_ID
COBRA_COVERAGE_ENROLLMENT_ID
ELEMENT_TYPE_ID
ACCEPT_REJECT_FLAG
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ATTRIBUTE16
ATTRIBUTE17
ATTRIBUTE18
ATTRIBUTE19
ATTRIBUTE20
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE