View: HRFV_DEF_BENEFIT_CONTRIBUTIONS

Product:	PER - Human Resources
Description:	Business view template from which the flexfield view is generated.
Implementation/DBA Data:	APPS.HRFV_DEF_BENEFIT_CONTRIBUTIONS

View Text

SELECT HOUT.NAME BUSINESS_GROUP_NAME
, ETT.ELEMENT_NAME BENEFIT_NAME
, BCS.BENEFIT_CLASSIFICATION_NAME BENEFIT_CLASSIFICATION_NAME
, ETT.DESCRIPTION DESCRIPTION
, BCO.EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, HR_DISCOVERER.CHECK_END_DATE(BCO.EFFECTIVE_END_DATE) EFFECTIVE_END_DATE
, HR_BIS.BIS_DECODE_LOOKUP('US_BENEFIT_COVERAGE'
, BCO.COVERAGE_TYPE) COVERAGE_TYPE
, TO_NUMBER(BCO.EMPLOYEE_CONTRIBUTION) EMPLOYEE_CONTRIBUTION
, TO_NUMBER(BCO.EMPLOYER_CONTRIBUTION) EMPLOYER_CONTRIBUTION
, BCO.EMPLOYEE_CONTRIBUTION + BCO.EMPLOYER_CONTRIBUTION TOTAL_CONTRIBUTION
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, BCS.COBRA_FLAG) COBRA_ELIGIBLE
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, BCS.DEPENDENTS_ALLOWED_FLAG) DEPENDENTS_COVERED_FLAG
, BCO.BENEFIT_CONTRIBUTION_ID BENEFIT_CONTRIBUTION_ID
, BCO.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, BCO.ELEMENT_TYPE_ID ELEMENT_TYPE_ID
, BCO.FORMULA_ID FORMULA_ID
FROM BEN_BENEFIT_CONTRIBUTIONS_F BCO
, BEN_BENEFIT_CLASSIFICATIONS BCS
, PAY_ELEMENT_TYPES_F_TL ETT
, PAY_ELEMENT_TYPES_F ET
, HR_ALL_ORGANIZATION_UNITS_TL HOUT
WHERE BCO.ELEMENT_TYPE_ID = ETT.ELEMENT_TYPE_ID
AND ET.ELEMENT_TYPE_ID = ETT.ELEMENT_TYPE_ID
AND ETT.LANGUAGE = USERENV('LANG')
AND BCS.BENEFIT_CLASSIFICATION_ID = ET.BENEFIT_CLASSIFICATION_ID
AND BCO.BUSINESS_GROUP_ID = HOUT.ORGANIZATION_ID
AND HOUT.LANGUAGE = USERENV('LANG')
AND BCO.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, BCO.BUSINESS_GROUP_ID) WITH READ ONLY

Columns