DBA Data[Home] [Help]

APPS.HR_ENTRY_API dependencies on BEN_BENEFIT_CONTRIBUTIONS_F

Line 753: from ben_benefit_contributions_f BCO

749: and ET.element_type_id = IV.element_type_id
750: and BCL.benefit_classification_id = ET.benefit_classification_id
751: and BCL.contributions_used = 'Y'
752: and not exists (select null
753: from ben_benefit_contributions_f BCO
754: where BCO.element_type_id = ET.element_type_id
755: and BCO.coverage_type = p_lookup_code
756: and v_session_date between BCO.effective_start_date
757: and BCO.effective_end_date);