DBA Data[Home] [Help]

APPS.BEN_ELP_CACHE dependencies on BEN_ELIG_BENFTS_GRP_PRTE_F

Line 8626: from ben_elig_benfts_grp_prte_f ebn

8622: where p_effective_date
8623: between elp.effective_start_date
8624: and elp.effective_end_date
8625: and exists(select null
8626: from ben_elig_benfts_grp_prte_f ebn
8627: where p_effective_date
8628: between ebn.effective_start_date
8629: and ebn.effective_end_date
8630: and ebn.eligy_prfl_id = elp.eligy_prfl_id)

Line 8641: from ben_elig_benfts_grp_prte_f ebn

8637: ebn.benfts_grp_id,
8638: ebn.excld_flag,
8639: ebn.criteria_score,
8640: ebn.criteria_weight
8641: from ben_elig_benfts_grp_prte_f ebn
8642: where p_effective_date
8643: between ebn.effective_start_date
8644: and ebn.effective_end_date
8645: order by ebn.eligy_prfl_id,