DBA Data[Home] [Help]

APPS.BEN_ELP_CACHE dependencies on BEN_ELIG_PYRL_PRTE_F

Line 7127: from ben_elig_pyrl_prte_f epy

7123: where p_effective_date
7124: between elp.effective_start_date
7125: and elp.effective_end_date
7126: and exists(select null
7127: from ben_elig_pyrl_prte_f epy
7128: where p_effective_date
7129: between epy.effective_start_date
7130: and epy.effective_end_date
7131: and epy.eligy_prfl_id = elp.eligy_prfl_id)

Line 7142: from ben_elig_pyrl_prte_f epy

7138: epy.payroll_id,
7139: epy.excld_flag,
7140: epy.criteria_score,
7141: epy.criteria_weight
7142: from ben_elig_pyrl_prte_f epy
7143: where p_effective_date
7144: between epy.effective_start_date
7145: and epy.effective_end_date
7146: order by epy.eligy_prfl_id,