DBA Data[Home] [Help]

APPS.BEN_CLS_UNRESOLVED_ACTN_ITEM dependencies on BEN_ELIG_CVRD_DPNT_F

Line 409: from ben_elig_cvrd_dpnt_f ecd,

405: select ecd.prtt_enrt_rslt_id,
406: ecd.dpnt_person_id,
407: ecd.cvg_strt_dt,
408: ecd.cvg_thru_dt
409: from ben_elig_cvrd_dpnt_f ecd,
410: ben_per_in_ler pil
411: where ecd.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
412: and ecd.business_group_id = p_business_group_id
413: and p_effective_date between ecd.effective_start_date