DBA Data[Home] [Help]

APPS.BEN_ELP_CACHE dependencies on BEN_ELIG_ASNT_SET_PRTE_F

Line 2601: from ben_elig_asnt_set_prte_f ean

2597: where p_effective_date
2598: between elp.effective_start_date
2599: and elp.effective_end_date
2600: and exists(select null
2601: from ben_elig_asnt_set_prte_f ean
2602: where p_effective_date
2603: between ean.effective_start_date
2604: and ean.effective_end_date
2605: and ean.eligy_prfl_id = elp.eligy_prfl_id)

Line 2616: from ben_elig_asnt_set_prte_f ean,

2612: ass.formula_id,
2613: ean.excld_flag,
2614: ean.criteria_score,
2615: ean.criteria_weight
2616: from ben_elig_asnt_set_prte_f ean,
2617: hr_assignment_sets ass
2618: where p_effective_date
2619: between ean.effective_start_date
2620: and ean.effective_end_date