APPS.BEN_MANAGE_LIFE_EVENTS dependencies on BEN_ELIG_DPNT

Line 3084: ben_elig_dpnt egd

3080: cursor c_in_pndg_edg is
3081: select
3082: elig_dpnt_id
3083: from
3084: ben_elig_dpnt egd
3085: where
3086: egd.per_in_ler_id = p_per_in_ler_id and
3087: egd.elig_per_elctbl_chc_id is null ;
3088:

Line 3097: ben_elig_dpnt_api.delete_elig_dpnt

3093: hr_utility.set_location('Entering '||l_package , 10);
3094: end if;
3095: for l_in_pndg_edg in c_in_pndg_edg loop
3096: --
3097: ben_elig_dpnt_api.delete_elig_dpnt
3098: (p_elig_dpnt_id => l_in_pndg_edg.elig_dpnt_id
3099: ,p_object_version_number => l_object_version_number
3100: ,p_effective_date => p_effective_date
3101: ) ;

Line 10132: ,ben_elig_dpnt egd

10128: cursor c_get_inelig_dpnt_info(p_per_in_ler_id in number) is
10129: -- RCHASE - wwBug1427383 - return correct date for creating dependent benefit assignment
10130: select pdp.dpnt_person_id, min(egd.elig_thru_dt) cvg_thru_dt--min(pdp.cvg_thru_dt) cvg_thru_dt
10131: from ben_elig_cvrd_dpnt_f pdp
10132: ,ben_elig_dpnt egd
10133: ,ben_prtt_enrt_rslt_f pen
10134: where pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
10135: and pen.person_id = p_person_id
10136: and pen.effective_end_date = hr_api.g_eot