DBA Data[Home] [Help]

APPS.BEN_MANAGE_OPEN_ENRT_WNDW dependencies on BEN_PER_IN_LER

Line 367: from ben_per_in_ler pil,

363: ler.name,
364: pel.pil_elctbl_chc_popl_id, pel.enrt_perd_strt_dt,
365: pel.enrt_perd_end_dt, pel.procg_end_dt, pel.dflt_enrt_dt,
366: pel.object_version_number
367: from ben_per_in_ler pil,
368: ben_ler_f ler,
369: ben_pil_elctbl_chc_popl pel,
370: per_all_people_f ppf
371: where pil.person_id = l_person_id

Line 872: from ben_per_in_ler pil

868: and l_effective_date
869: between ppf.effective_start_date
870: and ppf.effective_end_date
871: and exists (select null
872: from ben_per_in_ler pil
873: , ben_ler_f ler
874: where pil.lf_evt_ocrd_dt = nvl(l_lf_evt_ocrd_dt, pil.lf_evt_ocrd_dt)
875: and pil.ler_id = ler.ler_id
876: and l_effective_date between ler.effective_start_date