VIEW: APPS.PER_COBRA_COVERAGE_BENEFITS_V

Source

View Text - Preformatted

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 , hr_chkfmt.changeformat(CCB.COVERAGE_AMOUNT,'M','USD') 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')

View Text - HTML Formatted

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
, HR_CHKFMT.CHANGEFORMAT(CCB.COVERAGE_AMOUNT
, 'M'
, 'USD') 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')