APPS.BEN_AUTOMATIC_ENROLLMENTS dependencies on BEN_ELIG_DPNT

Line 199: from ben_elig_dpnt edg

195: and pdp_old.business_group_id = p_business_group_id;
196:
197: cursor c_epe_dpnt(l_elig_per_elctbl_chc_id number,l_dpnt_person_id number) is
198: select edg.*
199: from ben_elig_dpnt edg
200: where edg.elig_per_elctbl_chc_id = l_elig_per_elctbl_chc_id
201: and edg.business_group_id = p_business_group_id
202: and edg.dpnt_person_id = l_dpnt_person_id;
203:

Line 237: ben_elig_dpnt egd ,

233: v_dsgn_rqmt_id number ,
234: v_grp_rlshp_cd varchar2 ) is
235: select count(pdp.dpnt_person_id)
236: from ben_elig_cvrd_dpnt_f pdp,
237: ben_elig_dpnt egd ,
238: per_contact_relationships pcr
239: where pdp.business_group_id = p_business_group_id
240: and pdp.per_in_ler_id = v_per_in_ler_id
241: and pdp.prtt_enrt_rslt_id = v_prtt_enrt_rslt_id

Line 442: ben_ELIG_DPNT_api.process_dependent(

438: --
439: ben_sspndd_enrollment.g_cfw_dpnt_flag := 'Y' ;
440: hr_utility.set_location(' g_cfw_dpnt_flag '||ben_sspndd_enrollment.g_cfw_dpnt_flag,122);
441: --
442: ben_ELIG_DPNT_api.process_dependent(
443: p_elig_dpnt_id => l_epe_dpnt_rec.elig_dpnt_id,
444: p_business_group_id => p_business_group_id,
445: p_effective_date => p_effective_date,
446: p_cvg_strt_dt => l_cvg_strt_dt,