DBA Data[Home] [Help]

APPS.BEN_ELP_CACHE dependencies on BEN_ELIG_WK_LOC_PRTE_F

Line 4121: from ben_elig_wk_loc_prte_f ewl

4117: where p_effective_date
4118: between elp.effective_start_date
4119: and elp.effective_end_date
4120: and exists(select null
4121: from ben_elig_wk_loc_prte_f ewl
4122: where p_effective_date
4123: between ewl.effective_start_date
4124: and ewl.effective_end_date
4125: and ewl.eligy_prfl_id = elp.eligy_prfl_id)

Line 4136: from ben_elig_wk_loc_prte_f ewl

4132: ewl.location_id,
4133: ewl.excld_flag,
4134: ewl.criteria_score,
4135: ewl.criteria_weight
4136: from ben_elig_wk_loc_prte_f ewl
4137: where p_effective_date
4138: between ewl.effective_start_date
4139: and ewl.effective_end_date
4140: order by ewl.eligy_prfl_id,