DBA Data[Home] [Help]

APPS.BEN_ELP_CACHE dependencies on BEN_ELIG_NO_OTHR_CVG_PRTE_F

Line 9842: from ben_elig_no_othr_cvg_prte_f eno

9838: where p_effective_date
9839: between elp.effective_start_date
9840: and elp.effective_end_date
9841: and exists(select null
9842: from ben_elig_no_othr_cvg_prte_f eno
9843: where p_effective_date
9844: between eno.effective_start_date
9845: and eno.effective_end_date
9846: and eno.eligy_prfl_id = elp.eligy_prfl_id)

Line 9852: from ben_elig_no_othr_cvg_prte_f eno

9848: --
9849: cursor c_elpeno_inst is
9850: select eno.eligy_prfl_id,
9851: eno.coord_ben_no_cvg_flag
9852: from ben_elig_no_othr_cvg_prte_f eno
9853: where p_effective_date
9854: between eno.effective_start_date
9855: and eno.effective_end_date
9856: order by eno.eligy_prfl_id;