DBA Data[Home] [Help]

APPS.BEN_CLOSE_ENROLLMENT dependencies on BEN_ELIG_CVRD_DPNT_F

Line 67: from ben_elig_cvrd_dpnt_f ecd,

63: --
64: cursor c1 (c_prtt_enrt_rslt_id number)
65: is
66: select ecd.dpnt_person_id, ecd.cvg_strt_dt, ecd.cvg_thru_dt
67: from ben_elig_cvrd_dpnt_f ecd,
68: ben_per_in_ler pil
69: where ecd.prtt_enrt_rslt_id is not NULL
70: and ecd.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
71: and ecd.business_group_id = p_business_group_id