APPS.BEN_MANAGE_OPEN_ENRT_WNDW dependencies on BEN_PIL_ELCTBL_CHC_POPL

Line 369: ben_pil_elctbl_chc_popl pel,

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)
373: and pil.business_group_id+0 = p_business_group_id

Line 558: BEN_pil_elctbl_chc_popl_API.update_pil_elctbl_chc_popl

554: hr_utility.set_location('New ...dflt_enrt_dt'||l_new_dflt_enrt_dt,10);
555: end if;
556: /* Now updating the POPL record */
557: hr_utility.set_location('Updating POPL record : '||l_pel.pil_elctbl_chc_popl_id,10);
558: BEN_pil_elctbl_chc_popl_API.update_pil_elctbl_chc_popl
559: (p_validate => FALSE
560: ,p_PIL_ELCTBL_CHC_POPL_ID => l_pel.pil_elctbl_chc_popl_id
561: ,p_DFLT_ENRT_DT => l_new_dflt_enrt_dt
562: ,p_ENRT_PERD_END_DT => l_new_enrt_perd_end_dt

Line 886: from ben_pil_elctbl_chc_popl

882: and pil.business_group_id = p_business_group_id
883: and pil.person_id = ppf.person_id
884: and pil.business_group_id = ppf.business_group_id
885: and exists (select pil_elctbl_chc_popl_id
886: from ben_pil_elctbl_chc_popl
887: where per_in_ler_id = pil.per_in_ler_id
888: and ((p_pl_id is null and pgm_id = nvl(p_pgm_id, pgm_id)) or
889: (p_pgm_id is null and pl_id = nvl(p_pl_id, pl_id)))))
890: and (p_organization_id is null