DBA Data[Home] [Help]

APPS.BEN_ELP_CACHE dependencies on BEN_ELIG_WK_LOC_PRTE_F

Line 4191: from ben_elig_wk_loc_prte_f ewl

4187: where p_effective_date
4188: between elp.effective_start_date
4189: and elp.effective_end_date
4190: and exists(select null
4191: from ben_elig_wk_loc_prte_f ewl
4192: where p_effective_date
4193: between ewl.effective_start_date
4194: and ewl.effective_end_date
4195: and ewl.eligy_prfl_id = elp.eligy_prfl_id)

Line 4206: from ben_elig_wk_loc_prte_f ewl

4202: ewl.location_id,
4203: ewl.excld_flag,
4204: ewl.criteria_score,
4205: ewl.criteria_weight
4206: from ben_elig_wk_loc_prte_f ewl
4207: where p_effective_date
4208: between ewl.effective_start_date
4209: and ewl.effective_end_date
4210: order by ewl.eligy_prfl_id,