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 = p_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 = p_old_prtt_enrt_rslt_id

Line 178: from ben_elig_dpnt new2,

174: and p_effective_date between p.effective_start_date
175: and p.effective_end_date
176: and nvl(p.mx_dpnts_alwd_num,999) >=
177: (select count('s')
178: from ben_elig_dpnt new2,
179: per_contact_relationships pcr2
180: where new2.elig_per_elctbl_chc_id = p_new_elig_per_elctbl_chc_id
181: and new2.business_group_id = p_business_group_id
182: and new2.dpnt_person_id in

Line 261: ben_elig_dpnt new,

257: ( v_dsgn_rqmt_id number ,
258: v_grp_rlshp_cd varchar2 ) is
259: select count(old.elig_cvrd_dpnt_id)
260: from ben_elig_cvrd_dpnt_f old,
261: ben_elig_dpnt new,
262: ben_per_in_ler pil,
263: ben_per_in_ler pil2,
264: per_contact_relationships pcr
265: where old.prtt_enrt_rslt_id = p_old_prtt_enrt_rslt_id

Line 779: ben_ELIG_DPNT_api.process_dependent(

775: hr_utility.set_location('LAMC manage multi row', 20);
776: else hr_utility.set_location('LAMC manage NOT multi row', 20);
777: end if;
778:
779: ben_ELIG_DPNT_api.process_dependent(
780: p_elig_dpnt_id => p_elig_dpnt_id,
781: p_business_group_id => p_business_group_id,
782: p_effective_date => p_effective_date,
783: p_cvg_strt_dt => p_cvg_strt_dt,