DBA Data[Home] [Help]

APPS.BEN_ELP_CACHE dependencies on BEN_ELIG_GRD_PRTE_F

Line 6293: from ben_elig_grd_prte_f egr

6289: where p_effective_date
6290: between elp.effective_start_date
6291: and elp.effective_end_date
6292: and exists(select null
6293: from ben_elig_grd_prte_f egr
6294: where p_effective_date
6295: between egr.effective_start_date
6296: and egr.effective_end_date
6297: and egr.eligy_prfl_id = elp.eligy_prfl_id)

Line 6308: from ben_elig_grd_prte_f egr

6304: egr.grade_id,
6305: egr.excld_flag,
6306: egr.criteria_score,
6307: egr.criteria_weight
6308: from ben_elig_grd_prte_f egr
6309: where p_effective_date
6310: between egr.effective_start_date
6311: and egr.effective_end_date
6312: order by egr.eligy_prfl_id,

Line 6547: from ben_elig_grd_prte_f egn

6543: where p_effective_date
6544: between elp.effective_start_date
6545: and elp.effective_end_date
6546: and exists(select null
6547: from ben_elig_grd_prte_f egn
6548: where p_effective_date
6549: between egn.effective_start_date
6550: and egn.effective_end_date
6551: and egn.eligy_prfl_id = elp.eligy_prfl_id)