VIEW: APPS.PER_COBRA_COVERAGE_BENEFITS_D

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')