VIEW: APPS.BEN_BENEFIT_CONTRIBUTIONS_D

Source

View Text - Preformatted

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

View Text - HTML Formatted

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