DBA Data[Home] [Help]

APPS.BEN_ELP_CACHE dependencies on BEN_ELIGY_PRFL_RL_F

Line 2848: from ben_eligy_prfl_rl_f erl

2844: where p_effective_date
2845: between elp.effective_start_date
2846: and elp.effective_end_date
2847: and exists(select null
2848: from ben_eligy_prfl_rl_f erl
2849: where p_effective_date
2850: between erl.effective_start_date
2851: and erl.effective_end_date
2852: and erl.eligy_prfl_id = elp.eligy_prfl_id)

Line 2862: from ben_eligy_prfl_rl_f erl

2858: 'ERL' short_code,
2859: erl.formula_id,
2860: erl.criteria_score,
2861: erl.criteria_weight
2862: from ben_eligy_prfl_rl_f erl
2863: where p_effective_date
2864: between erl.effective_start_date
2865: and erl.effective_end_date
2866: order by erl.eligy_prfl_id,