APPS.BEN_MANAGE_LIFE_EVENTS dependencies on BEN_ELIG_DPNT

Line 2692: ben_elig_dpnt egd

2688: cursor c_in_pndg_edg is
2689: select
2690: elig_dpnt_id
2691: from
2692: ben_elig_dpnt egd
2693: where
2694: egd.per_in_ler_id = p_per_in_ler_id and
2695: egd.elig_per_elctbl_chc_id is null ;
2696:

Line 2705: ben_elig_dpnt_api.delete_elig_dpnt

2701: hr_utility.set_location('Entering '||l_package , 10);
2702: end if;
2703: for l_in_pndg_edg in c_in_pndg_edg loop
2704: --
2705: ben_elig_dpnt_api.delete_elig_dpnt
2706: (p_elig_dpnt_id => l_in_pndg_edg.elig_dpnt_id
2707: ,p_object_version_number => l_object_version_number
2708: ,p_effective_date => p_effective_date
2709: ) ;

Line 9724: ,ben_elig_dpnt egd

9720: cursor c_get_inelig_dpnt_info(p_per_in_ler_id in number) is
9721: -- RCHASE - wwBug1427383 - return correct date for creating dependent benefit assignment
9722: select pdp.dpnt_person_id, min(egd.elig_thru_dt) cvg_thru_dt--min(pdp.cvg_thru_dt) cvg_thru_dt
9723: from ben_elig_cvrd_dpnt_f pdp
9724: ,ben_elig_dpnt egd
9725: ,ben_prtt_enrt_rslt_f pen
9726: where pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
9727: and pen.person_id = p_person_id
9728: and pen.effective_end_date = hr_api.g_eot