APPS.BEN_MNG_DPNT_BNF dependencies on BEN_ELIG_CVRD_DPNT_F

Line 110: from ben_elig_cvrd_dpnt_f old,

106: -- it's just used to check if there are any before continuing.
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

Line 137: from ben_elig_cvrd_dpnt_f old,

133: -- are no individual rlshp restrictions or we meet the restrictions.
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

Line 185: from ben_elig_cvrd_dpnt_f ecd

181: and new2.business_group_id = p_business_group_id
182: and new2.dpnt_person_id in
183: -- Make sure that the dpnt being counted was covered before
184: (select dpnt_person_id
185: from ben_elig_cvrd_dpnt_f ecd
186: where prtt_enrt_rslt_id = p_old_prtt_enrt_rslt_id
187: and cvg_strt_dt is not null
188: and nvl(cvg_thru_dt, hr_api.g_eot) >=
189: nvl(pil2.lf_evt_ocrd_dt - 1, hr_api.g_eot)

Line 231: from ben_elig_cvrd_dpnt_f ecd,

227: select ecd.elig_cvrd_dpnt_id,
228: ecd.dpnt_person_id,
229: ecd.elig_per_elctbl_chc_id,
230: ecd.object_version_number
231: from ben_elig_cvrd_dpnt_f ecd,
232: ben_per_in_ler pil
233: where ecd.prtt_enrt_rslt_id = p_new_prtt_enrt_rslt_id
234: and ecd.cvg_strt_dt is not null
235: and nvl(ecd.cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot

Line 260: from ben_elig_cvrd_dpnt_f old,

256: cursor c_tot_elig_dpnt
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