APPS.BEN_CARRY_FORWARD_ITEMS dependencies on BEN_ELIG_DPNT

Line 491: from ben_elig_dpnt edg

487: and pdp_old.business_group_id = p_business_group_id;
488:
489: cursor c_epe_dpnt(l_elig_per_elctbl_chc_id number,l_dpnt_person_id number) is
490: select edg.*
491: from ben_elig_dpnt edg
492: where edg.elig_per_elctbl_chc_id = l_elig_per_elctbl_chc_id
493: and edg.business_group_id = p_business_group_id
494: and edg.dpnt_person_id = l_dpnt_person_id;
495:

Line 529: ben_elig_dpnt egd ,

525: v_dsgn_rqmt_id number ,
526: v_grp_rlshp_cd varchar2 ) is
527: select count(pdp.dpnt_person_id)
528: from ben_elig_cvrd_dpnt_f pdp,
529: ben_elig_dpnt egd ,
530: per_contact_relationships pcr
531: where pdp.business_group_id = p_business_group_id
532: and pdp.per_in_ler_id = v_per_in_ler_id
533: and pdp.prtt_enrt_rslt_id = v_prtt_enrt_rslt_id

Line 730: ben_ELIG_DPNT_api.process_dependent(

726: fetch c_epe_dpnt into l_epe_dpnt_rec;
727: if c_epe_dpnt%notfound then
728: null;
729: else
730: ben_ELIG_DPNT_api.process_dependent(
731: p_elig_dpnt_id => l_epe_dpnt_rec.elig_dpnt_id,
732: p_business_group_id => p_business_group_id,
733: p_effective_date => p_effective_date,
734: p_cvg_strt_dt => l_cvg_strt_dt,