APPS.BEN_MANAGE_OPEN_ENRT_WNDW dependencies on BEN_LER_F

Line 368: ben_ler_f ler,

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
372: and pil.lf_evt_ocrd_dt = nvl(l_lf_evt_ocrd_dt,pil.lf_evt_ocrd_dt)

Line 873: , ben_ler_f ler

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
877: and ler.effective_end_date

Line 973: l_ler_id ben_ler_f.ler_id%type;

969: l_benefit_action_id ben_benefit_actions.benefit_action_id%type;
970: l_object_version_number ben_benefit_actions.object_version_number%type;
971: l_person_id per_people_f.person_id%type;
972: l_person_action_id ben_person_actions.person_action_id%type;
973: l_ler_id ben_ler_f.ler_id%type;
974: l_range_id ben_batch_ranges.range_id%type;
975: l_chunk_size number := 20;
976: l_threads number := 1;
977: l_start_person_action_id number := 0;