DBA Data[Home] [Help]

APPS.BEN_EXT_ANSI dependencies on BEN_ELIG_CVRD_DPNT_F

Line 58: ben_elig_cvrd_dpnt_f dpnt

54: --
55: cursor c_dpnt_of_distinct_participant is
56: select distinct rslt.person_id
57: FROM ben_prtt_enrt_rslt_f rslt,
58: ben_elig_cvrd_dpnt_f dpnt
59: WHERE rslt.prtt_enrt_rslt_id = dpnt.prtt_enrt_rslt_id
60: AND dpnt.dpnt_person_id = p_person_id
61: --AND p_effective_date between rslt.enrt_cvg_strt_dt
62: -- and rslt.enrt_cvg_thru_dt

Line 86: ben_elig_cvrd_dpnt_f dpnt,

82: pil.per_in_ler_stat_cd,
83: pil.lf_evt_ocrd_dt,
84: pil.ntfn_dt
85: FROM ben_prtt_enrt_rslt_f rslt,
86: ben_elig_cvrd_dpnt_f dpnt,
87: ben_per_in_ler pil
88: WHERE rslt.prtt_enrt_rslt_id = dpnt.prtt_enrt_rslt_id
89: and rslt.per_in_ler_id = pil.per_in_ler_id(+)
90: AND dpnt.dpnt_person_id = p_dpnt_person_id