APPS.BEN_DETERMINE_DPNT_ELIG_SS dependencies on BEN_ELIG_DPNT

Line 113: from ben_elig_dpnt epe

109: p_effective_date date) is
110: select epe.elig_dpnt_id,
111: epe.object_version_number,
112: epe.dpnt_inelig_flag
113: from ben_elig_dpnt epe
114: where epe.dpnt_person_id = p_dpnt_person_id
115: and epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id;
116: --bug 2419139
117: --and p_effective_date between

Line 369: ben_ELIG_DPNT_api.get_elig_per_id(

365: --
366: else
367: --
368:
369: ben_ELIG_DPNT_api.get_elig_per_id(
370: p_person_id => p_person_id
371: ,p_pgm_id => p_pgm_id
372: ,p_pl_id => epe.pl_id
373: ,p_oipl_id => epe.oipl_id

Line 379: ben_elig_dpnt_api.create_elig_dpnt

375: ,p_effective_date => p_effective_date
376: ,p_elig_per_id => l_elig_per_id
377: ,p_elig_per_opt_id => l_elig_per_opt_id);
378: --
379: ben_elig_dpnt_api.create_elig_dpnt
380: (p_validate => FALSE
381: ,p_ELIG_DPNT_ID => l_ELIG_DPNT_ID --out
382: ,p_create_dt => p_effective_date
383: ,p_ELIG_CVRD_DPNT_ID => null

Line 416: ben_elig_dpnt_api.update_elig_dpnt(

412: if l_dependent_eligible_flag = 'Y' then
413: --
414: if l_elig_dpnt.dpnt_inelig_flag = 'Y' then
415: --
416: ben_elig_dpnt_api.update_elig_dpnt(
417: p_elig_dpnt_id => l_elig_dpnt.elig_dpnt_id
418: ,p_object_version_number => l_elig_dpnt.object_version_number
419: ,p_effective_date => p_effective_date
420: ,p_elig_thru_dt => hr_api.g_eot

Line 620: ben_elig_dpnt_api.update_elig_dpnt(

616: end if; -- l_prtt_enrt_rslt_id not null
617:
618: if l_elig_dpnt.dpnt_inelig_flag = 'N' then
619: --
620: ben_elig_dpnt_api.update_elig_dpnt(
621: p_elig_dpnt_id => l_elig_dpnt.elig_dpnt_id
622: ,p_object_version_number => l_elig_dpnt.object_version_number
623: ,p_effective_date => p_effective_date
624: ,p_elig_thru_dt => l_egd_elig_thru_dt --l_cvg_end_dt -- 5100008