DBA Data[Home] [Help]

APPS.BEN_ELP_CACHE dependencies on BEN_ELIG_ASNT_SET_PRTE_F

Line 2618: from ben_elig_asnt_set_prte_f ean

2614: where p_effective_date
2615: between elp.effective_start_date
2616: and elp.effective_end_date
2617: and exists(select null
2618: from ben_elig_asnt_set_prte_f ean
2619: where p_effective_date
2620: between ean.effective_start_date
2621: and ean.effective_end_date
2622: and ean.eligy_prfl_id = elp.eligy_prfl_id)

Line 2633: from ben_elig_asnt_set_prte_f ean,

2629: ass.formula_id,
2630: ean.excld_flag,
2631: ean.criteria_score,
2632: ean.criteria_weight
2633: from ben_elig_asnt_set_prte_f ean,
2634: hr_assignment_sets ass
2635: where p_effective_date
2636: between ean.effective_start_date
2637: and ean.effective_end_date