DBA Data[Home] [Help]

APPS.BEN_ELP_CACHE dependencies on BEN_ELIG_LVG_RSN_PRTE_F

Line 11354: from ben_elig_lvg_rsn_prte_f elv

11350: where p_effective_date
11351: between elp.effective_start_date
11352: and elp.effective_end_date
11353: and exists(select null
11354: from ben_elig_lvg_rsn_prte_f elv
11355: where p_effective_date
11356: between elv.effective_start_date
11357: and elv.effective_end_date
11358: and elv.eligy_prfl_id = elp.eligy_prfl_id)

Line 11369: from ben_elig_lvg_rsn_prte_f elv

11365: elv.lvg_rsn_cd,
11366: elv.excld_flag,
11367: elv.criteria_score,
11368: elv.criteria_weight
11369: from ben_elig_lvg_rsn_prte_f elv
11370: where p_effective_date
11371: between elv.effective_start_date
11372: and elv.effective_end_date
11373: order by elv.eligy_prfl_id,