DBA Data[Home] [Help]

APPS.BEN_ELP_CACHE dependencies on BEN_ELIG_PYRL_PRTE_F

Line 7305: from ben_elig_pyrl_prte_f epy

7301: where p_effective_date
7302: between elp.effective_start_date
7303: and elp.effective_end_date
7304: and exists(select null
7305: from ben_elig_pyrl_prte_f epy
7306: where p_effective_date
7307: between epy.effective_start_date
7308: and epy.effective_end_date
7309: and epy.eligy_prfl_id = elp.eligy_prfl_id)

Line 7320: from ben_elig_pyrl_prte_f epy

7316: epy.payroll_id,
7317: epy.excld_flag,
7318: epy.criteria_score,
7319: epy.criteria_weight
7320: from ben_elig_pyrl_prte_f epy
7321: where p_effective_date
7322: between epy.effective_start_date
7323: and epy.effective_end_date
7324: order by epy.eligy_prfl_id,