DBA Data[Home] [Help]

APPS.BEN_ELP_CACHE dependencies on BEN_ELIGY_PRFL_RL_F

Line 2873: from ben_eligy_prfl_rl_f erl

2869: where p_effective_date
2870: between elp.effective_start_date
2871: and elp.effective_end_date
2872: and exists(select null
2873: from ben_eligy_prfl_rl_f erl
2874: where p_effective_date
2875: between erl.effective_start_date
2876: and erl.effective_end_date
2877: and erl.eligy_prfl_id = elp.eligy_prfl_id)

Line 2887: from ben_eligy_prfl_rl_f erl

2883: 'ERL' short_code,
2884: erl.formula_id,
2885: erl.criteria_score,
2886: erl.criteria_weight
2887: from ben_eligy_prfl_rl_f erl
2888: where p_effective_date
2889: between erl.effective_start_date
2890: and erl.effective_end_date
2891: order by erl.eligy_prfl_id,