View: BEN_BENEFIT_CONTRIBUTIONS_D

Product:	PER - Human Resources
Description:	Used by Datetrack History
Implementation/DBA Data:	APPS.BEN_BENEFIT_CONTRIBUTIONS_D

View Text

SELECT BEN.BENEFIT_CONTRIBUTION_ID
, BEN.EFFECTIVE_START_DATE
, BEN.EFFECTIVE_END_DATE
, FF.FORMULA_NAME
, ET.ELEMENT_NAME
, HR1.MEANING
, BEN.EMPLOYEE_CONTRIBUTION
, BEN.EMPLOYER_CONTRIBUTION
, BEN.MAXIMUM_EMPLOYEE_CONTRIBUTION
, BEN.MAXIMUM_EMPLOYER_CONTRIBUTION
, BEN.MINIMUM_EMPLOYEE_CONTRIBUTION
, BEN.MINIMUM_EMPLOYER_CONTRIBUTION
, BEN.LAST_UPDATE_DATE
, FU.USER_NAME
FROM BEN_BENEFIT_CONTRIBUTIONS_F BEN
, PAY_ELEMENT_TYPES_F ET
, FF_FORMULAS_F FF
, FND_USER FU
, HR_LOOKUPS HR1
WHERE BEN.FORMULA_ID = FF.FORMULA_ID (+)
AND BEN.EFFECTIVE_START_DATE BETWEEN NVL(FF.EFFECTIVE_START_DATE
, BEN.EFFECTIVE_START_DATE)
AND NVL(FF.EFFECTIVE_END_DATE
, BEN.EFFECTIVE_START_DATE)
AND BEN.ELEMENT_TYPE_ID = ET.ELEMENT_TYPE_ID (+)
AND BEN.EFFECTIVE_START_DATE BETWEEN NVL(ET.EFFECTIVE_START_DATE
, BEN.EFFECTIVE_START_DATE)
AND NVL(ET.EFFECTIVE_END_DATE
, BEN.EFFECTIVE_START_DATE)
AND BEN.LAST_UPDATED_BY = FU.USER_ID (+)
AND HR1.LOOKUP_TYPE (+) = 'COVERAGE_TYPE'
AND HR1.LOOKUP_CODE (+) = BEN.COVERAGE_TYPE

Columns