DBA Data[Home] [Help]

APPS.BEN_ELP_CACHE dependencies on BEN_ELIG_LOA_RSN_PRTE_F

Line 7862: from ben_elig_loa_rsn_prte_f elr

7858: where p_effective_date
7859: between elp.effective_start_date
7860: and elp.effective_end_date
7861: and exists(select null
7862: from ben_elig_loa_rsn_prte_f elr
7863: where p_effective_date
7864: between elr.effective_start_date
7865: and elr.effective_end_date
7866: and elr.eligy_prfl_id = elp.eligy_prfl_id)

Line 7878: from ben_elig_loa_rsn_prte_f elr

7874: elr.abs_attendance_reason_id,
7875: elr.excld_flag,
7876: elr.criteria_score,
7877: elr.criteria_weight
7878: from ben_elig_loa_rsn_prte_f elr
7879: where p_effective_date
7880: between elr.effective_start_date
7881: and elr.effective_end_date
7882: order by elr.eligy_prfl_id,