DBA Data[Home] [Help]

APPS.BEN_ELP_CACHE dependencies on BEN_ELIG_LVG_RSN_PRTE_F

Line 11032: from ben_elig_lvg_rsn_prte_f elv

11028: where p_effective_date
11029: between elp.effective_start_date
11030: and elp.effective_end_date
11031: and exists(select null
11032: from ben_elig_lvg_rsn_prte_f elv
11033: where p_effective_date
11034: between elv.effective_start_date
11035: and elv.effective_end_date
11036: and elv.eligy_prfl_id = elp.eligy_prfl_id)

Line 11047: from ben_elig_lvg_rsn_prte_f elv

11043: elv.lvg_rsn_cd,
11044: elv.excld_flag,
11045: elv.criteria_score,
11046: elv.criteria_weight
11047: from ben_elig_lvg_rsn_prte_f elv
11048: where p_effective_date
11049: between elv.effective_start_date
11050: and elv.effective_end_date
11051: order by elv.eligy_prfl_id,