[Home] [Help]
View: 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
BENEFIT_CONTRIBUTION_ID |
EFFECTIVE_START_DATE |
EFFECTIVE_END_DATE |
FORMULA_NAME |
ELEMENT_NAME |
COVERAGE_TYPE |
EMPLOYEE_CONTRIBUTION |
EMPLOYER_CONTRIBUTION |
MAXIMUM_EMPLOYEE_CONTRIBUTION |
MAXIMUM_EMPLOYER_CONTRIBUTION |
MINIMUM_EMPLOYEE_CONTRIBUTION |
MINIMUM__EMPLOYER_CONTRIBUTION |
LAST_UPDATE_DATE |
LAST_UPDATE_BY |
Name |