[Home] [Help]
APPS.BEN_CLOSE_ENROLLMENT dependencies on BEN_ELIG_CVRD_DPNT_F
Line 66: from ben_elig_cvrd_dpnt_f ecd,
62: --
63: cursor c1 (c_prtt_enrt_rslt_id number)
64: is
65: select ecd.dpnt_person_id, ecd.cvg_strt_dt, ecd.cvg_thru_dt
66: from ben_elig_cvrd_dpnt_f ecd,
67: ben_per_in_ler pil
68: where ecd.prtt_enrt_rslt_id is not NULL
69: and ecd.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
70: and ecd.business_group_id = p_business_group_id