View: PER_COBRA_COVERAGE_BENEFITS_D

Product:	PER - Human Resources
Description:	Used by Datetrack History
Implementation/DBA Data:	APPS.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