Product: | PER - Human Resources |
---|---|
Description: | Used to support user interface |
Implementation/DBA Data: | APPS.PER_COBRA_COVERAGE_STATUSES_V |
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