DBA Data[Home] [Help]

APPS.BEN_ELP_CACHE dependencies on BEN_ELIG_DPNT_OTHR_PTIP_F

Line 9600: from ben_elig_dpnt_othr_ptip_f etd

9596: where p_effective_date
9597: between elp.effective_start_date
9598: and elp.effective_end_date
9599: and exists(select null
9600: from ben_elig_dpnt_othr_ptip_f etd
9601: where p_effective_date
9602: between etd.effective_start_date
9603: and etd.effective_end_date
9604: and etd.eligy_prfl_id = elp.eligy_prfl_id)

Line 9612: from ben_elig_dpnt_othr_ptip_f etd

9608: select etd.eligy_prfl_id,
9609: etd.ptip_id,
9610: --etd.only_pls_subj_cobra_flag,
9611: etd.excld_flag
9612: from ben_elig_dpnt_othr_ptip_f etd
9613: where p_effective_date
9614: between etd.effective_start_date
9615: and etd.effective_end_date
9616: order by etd.eligy_prfl_id,