DBA Data[Home] [Help]

APPS.BEN_ELP_CACHE dependencies on BEN_ELIG_DPNT_CVRD_OTHR_PL_F

Line 10793: from ben_elig_dpnt_cvrd_othr_pl_f edp

10789: where p_effective_date
10790: between elp.effective_start_date
10791: and elp.effective_end_date
10792: and exists(select null
10793: from ben_elig_dpnt_cvrd_othr_pl_f edp
10794: where p_effective_date
10795: between edp.effective_start_date
10796: and edp.effective_end_date
10797: and edp.eligy_prfl_id = elp.eligy_prfl_id)

Line 10805: from ben_elig_dpnt_cvrd_othr_pl_f edp

10801: select edp.eligy_prfl_id,
10802: edp.pl_id,
10803: edp.cvg_det_dt_cd,
10804: edp.excld_flag
10805: from ben_elig_dpnt_cvrd_othr_pl_f edp
10806: where p_effective_date
10807: between edp.effective_start_date
10808: and edp.effective_end_date
10809: order by edp.eligy_prfl_id,