APPS.BEN_MNG_DPNT_BNF dependencies on BEN_ELIG_DPNT

Line 111: ben_elig_dpnt new,

107: --
108: cursor c_num_cvd_dpnt is
109: select count(old.elig_cvrd_dpnt_id)
110: from ben_elig_cvrd_dpnt_f old,
111: ben_elig_dpnt new,
112: ben_per_in_ler pil,
113: ben_per_in_ler pil2
114: where old.prtt_enrt_rslt_id = l_old_prtt_enrt_rslt_id
115: and old.cvg_strt_dt is not null

Line 138: ben_elig_dpnt new,

134: cursor copy_dpnt_c is
135: select old.elig_cvrd_dpnt_id old_dpnt,
136: new.elig_dpnt_id new_dpnt
137: from ben_elig_cvrd_dpnt_f old,
138: ben_elig_dpnt new,
139: per_contact_relationships pcr,
140: ben_per_in_ler pil,
141: ben_per_in_ler pil2
142: where old.prtt_enrt_rslt_id = l_old_prtt_enrt_rslt_id

Line 172: (select '1' from ben_elig_dpnt edp,

168: and pen1.enrt_cvg_thru_dt = hr_api.g_eot)
169: )) --'Y'
170: and old.cvg_thru_dt <> hr_api.g_eot
171: and ('Y' = (select 'Y' from dual where exists
172: (select '1' from ben_elig_dpnt edp,
173: ben_elig_per_elctbl_chc epe
174: where edp.dpnt_person_id = old.dpnt_person_id
175: and edp.per_in_ler_id = new.per_in_ler_id
176: and epe.prtt_enrt_rslt_id = p_old_prtt_enrt_rslt_id

Line 263: from ben_elig_dpnt new2,

259: and p_effective_date between p.effective_start_date
260: and p.effective_end_date
261: and nvl(p.mx_dpnts_alwd_num,999) >=
262: (select count('s')
263: from ben_elig_dpnt new2,
264: per_contact_relationships pcr2
265: where new2.elig_per_elctbl_chc_id = p_new_elig_per_elctbl_chc_id
266: and new2.business_group_id = p_business_group_id
267: and new2.dpnt_person_id in

Line 346: ben_elig_dpnt new,

342: ( v_dsgn_rqmt_id number ,
343: v_grp_rlshp_cd varchar2 ) is
344: select count(old.elig_cvrd_dpnt_id)
345: from ben_elig_cvrd_dpnt_f old,
346: ben_elig_dpnt new,
347: ben_per_in_ler pil,
348: ben_per_in_ler pil2,
349: per_contact_relationships pcr
350: where old.prtt_enrt_rslt_id = l_old_prtt_enrt_rslt_id

Line 927: ben_ELIG_DPNT_api.process_dependent(

923: hr_utility.set_location('LAMC manage multi row', 20);
924: else hr_utility.set_location('LAMC manage NOT multi row', 20);
925: end if;
926:
927: ben_ELIG_DPNT_api.process_dependent(
928: p_elig_dpnt_id => p_elig_dpnt_id,
929: p_business_group_id => p_business_group_id,
930: p_effective_date => p_effective_date,
931: p_cvg_strt_dt => p_cvg_strt_dt,