[Home] [Help]
View: PER_COBRA_COVERAGE_BENEFITS_D
View Text
SELECT CCB.COBRA_COVERAGE_BENEFIT_ID
, CCB.EFFECTIVE_START_DATE
, CCB.EFFECTIVE_END_DATE
, L2.MEANING
, BC2.BENEFIT_CLASSIFICATION_NAME
, ETTL.ELEMENT_NAME
, L1.MEANING
, CCB.COVERAGE_AMOUNT
, CCB.LAST_UPDATE_DATE
, FU.USER_NAME
FROM PER_COBRA_COVERAGE_BENEFITS_F CCB
, HR_LOOKUPS L1
, HR_LOOKUPS L2
, BEN_BENEFIT_CLASSIFICATIONS BC2
, PAY_ELEMENT_TYPES_F ET
, PAY_ELEMENT_TYPES_F_TL ETTL
, FND_USER FU
WHERE BC2.BENEFIT_CLASSIFICATION_ID = ET.BENEFIT_CLASSIFICATION_ID
AND ET.ELEMENT_TYPE_ID = ETTL.ELEMENT_TYPE_ID
AND L1.LOOKUP_TYPE = 'COVERAGE_TYPE'
AND L1.LOOKUP_CODE = CCB.COVERAGE_TYPE
AND ET.ELEMENT_TYPE_ID = CCB.ELEMENT_TYPE_ID
AND CCB.EFFECTIVE_START_DATE BETWEEN ET.EFFECTIVE_START_DATE
AND ET.EFFECTIVE_END_DATE
AND L2.LOOKUP_TYPE = 'YES_NO'
AND ( (CCB.ACCEPT_REJECT_FLAG = 'ACC'
AND L2.LOOKUP_CODE = 'Y') OR (CCB.ACCEPT_REJECT_FLAG = 'REJ'
AND L2.LOOKUP_CODE = 'N'))
AND FU.USER_ID (+)= CCB.LAST_UPDATED_BY
AND ETTL.LANGUAGE = USERENV('LANG')
Columns
Name |
COBRA_COVERAGE_BENEFIT_ID |
EFFECTIVE_START_DATE |
EFFECTIVE_END_DATE |
ACCEPTED |
CLASSIFICATION |
NAME |
COVERAGE |
COBRA_COSTS |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |