DBA Data[Home] [Help]

APPS.BEN_ELP_CACHE dependencies on BEN_ELIG_GRD_PRTE_F

Line 6151: from ben_elig_grd_prte_f egr

6147: where p_effective_date
6148: between elp.effective_start_date
6149: and elp.effective_end_date
6150: and exists(select null
6151: from ben_elig_grd_prte_f egr
6152: where p_effective_date
6153: between egr.effective_start_date
6154: and egr.effective_end_date
6155: and egr.eligy_prfl_id = elp.eligy_prfl_id)

Line 6166: from ben_elig_grd_prte_f egr

6162: egr.grade_id,
6163: egr.excld_flag,
6164: egr.criteria_score,
6165: egr.criteria_weight
6166: from ben_elig_grd_prte_f egr
6167: where p_effective_date
6168: between egr.effective_start_date
6169: and egr.effective_end_date
6170: order by egr.eligy_prfl_id,

Line 6396: from ben_elig_grd_prte_f egn

6392: where p_effective_date
6393: between elp.effective_start_date
6394: and elp.effective_end_date
6395: and exists(select null
6396: from ben_elig_grd_prte_f egn
6397: where p_effective_date
6398: between egn.effective_start_date
6399: and egn.effective_end_date
6400: and egn.eligy_prfl_id = elp.eligy_prfl_id)