VIEW: APPS.PER_COBRA_COVERAGE_STATUSES_V

Source

View Text - Preformatted

SELECT CCS.ROWID ROW_ID , CCS.COBRA_COVERAGE_STATUS_ID COBRA_COVERAGE_STATUS_ID , CCS.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID , CCS.COBRA_COVERAGE_ENROLLMENT_ID COBRA_COVERAGE_ENROLLMENT_ID , CCS.COBRA_COVERAGE_STATUS_TYPE COBRA_COVERAGE_STATUS_TYPE , L1.MEANING STATUS_TYPE_MEANING , CCS.EFFECTIVE_DATE EFFECTIVE_DATE , CCS.COMMENTS COMMENTS , CCS.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY , CCS.ATTRIBUTE1 ATTRIBUTE1 , CCS.ATTRIBUTE2 ATTRIBUTE2 , CCS.ATTRIBUTE3 ATTRIBUTE3 , CCS.ATTRIBUTE4 ATTRIBUTE4 , CCS.ATTRIBUTE5 ATTRIBUTE5 , CCS.ATTRIBUTE6 ATTRIBUTE6 , CCS.ATTRIBUTE7 ATTRIBUTE7 , CCS.ATTRIBUTE8 ATTRIBUTE8 , CCS.ATTRIBUTE9 ATTRIBUTE9 , CCS.ATTRIBUTE10 ATTRIBUTE10 , CCS.ATTRIBUTE11 ATTRIBUTE11 , CCS.ATTRIBUTE12 ATTRIBUTE12 , CCS.ATTRIBUTE13 ATTRIBUTE13 , CCS.ATTRIBUTE14 ATTRIBUTE14 , CCS.ATTRIBUTE15 ATTRIBUTE15 , CCS.ATTRIBUTE16 ATTRIBUTE16 , CCS.ATTRIBUTE17 ATTRIBUTE17 , CCS.ATTRIBUTE18 ATTRIBUTE18 , CCS.ATTRIBUTE19 ATTRIBUTE19 , CCS.ATTRIBUTE20 ATTRIBUTE20 , CCS.LAST_UPDATE_DATE LAST_UPDATE_DATE , CCS.LAST_UPDATED_BY LAST_UPDATED_BY , CCS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN , CCS.CREATED_BY CREATED_BY , CCS.CREATION_DATE CREATION_DATE FROM HR_LOOKUPS L1, PER_COBRA_COVERAGE_STATUSES CCS WHERE L1.LOOKUP_TYPE = 'US_COBRA_STATUS' AND CCS.COBRA_COVERAGE_STATUS_TYPE = L1.LOOKUP_CODE

View Text - HTML Formatted

SELECT CCS.ROWID ROW_ID
, CCS.COBRA_COVERAGE_STATUS_ID COBRA_COVERAGE_STATUS_ID
, CCS.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID
, CCS.COBRA_COVERAGE_ENROLLMENT_ID COBRA_COVERAGE_ENROLLMENT_ID
, CCS.COBRA_COVERAGE_STATUS_TYPE COBRA_COVERAGE_STATUS_TYPE
, L1.MEANING STATUS_TYPE_MEANING
, CCS.EFFECTIVE_DATE EFFECTIVE_DATE
, CCS.COMMENTS COMMENTS
, CCS.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CCS.ATTRIBUTE1 ATTRIBUTE1
, CCS.ATTRIBUTE2 ATTRIBUTE2
, CCS.ATTRIBUTE3 ATTRIBUTE3
, CCS.ATTRIBUTE4 ATTRIBUTE4
, CCS.ATTRIBUTE5 ATTRIBUTE5
, CCS.ATTRIBUTE6 ATTRIBUTE6
, CCS.ATTRIBUTE7 ATTRIBUTE7
, CCS.ATTRIBUTE8 ATTRIBUTE8
, CCS.ATTRIBUTE9 ATTRIBUTE9
, CCS.ATTRIBUTE10 ATTRIBUTE10
, CCS.ATTRIBUTE11 ATTRIBUTE11
, CCS.ATTRIBUTE12 ATTRIBUTE12
, CCS.ATTRIBUTE13 ATTRIBUTE13
, CCS.ATTRIBUTE14 ATTRIBUTE14
, CCS.ATTRIBUTE15 ATTRIBUTE15
, CCS.ATTRIBUTE16 ATTRIBUTE16
, CCS.ATTRIBUTE17 ATTRIBUTE17
, CCS.ATTRIBUTE18 ATTRIBUTE18
, CCS.ATTRIBUTE19 ATTRIBUTE19
, CCS.ATTRIBUTE20 ATTRIBUTE20
, CCS.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CCS.LAST_UPDATED_BY LAST_UPDATED_BY
, CCS.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CCS.CREATED_BY CREATED_BY
, CCS.CREATION_DATE CREATION_DATE
FROM HR_LOOKUPS L1
, PER_COBRA_COVERAGE_STATUSES CCS
WHERE L1.LOOKUP_TYPE = 'US_COBRA_STATUS'
AND CCS.COBRA_COVERAGE_STATUS_TYPE = L1.LOOKUP_CODE