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 = l_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 202: and pdp_old.bkup_tbl_typ_cd = 'BEN_ELIG_CVRD_DPNT_F'))))

198: and pdp_old.prtt_enrt_rslt_id = l_old_prtt_enrt_rslt_id
199: and pdp_old.business_group_id = p_business_group_id
200: and pdp_old.dpnt_person_id = old.dpnt_person_id
201: and pdp_old.cvg_thru_dt <> hr_api.g_eot
202: and pdp_old.bkup_tbl_typ_cd = 'BEN_ELIG_CVRD_DPNT_F'))))
203: or (l_old_prtt_enrt_rslt_id <> p_new_prtt_enrt_rslt_id
204: and ('1' = (select '1' from dual where
205: exists
206: (select '1' from ben_le_clsn_n_rstr pdp_old

Line 213: and pdp_old.bkup_tbl_typ_cd = 'BEN_ELIG_CVRD_DPNT_F'

209: and pdp_old.prtt_enrt_rslt_id <> l_old_prtt_enrt_rslt_id
210: and pdp_old.business_group_id = p_business_group_id
211: and pdp_old.dpnt_person_id = old.dpnt_person_id
212: and pdp_old.cvg_thru_dt = hr_api.g_eot
213: and pdp_old.bkup_tbl_typ_cd = 'BEN_ELIG_CVRD_DPNT_F'
214: and pen5.per_in_ler_id = ben_manage_life_events.g_bckdt_per_in_ler_id
215: and pen5.prtt_enrt_rslt_id <> l_old_prtt_enrt_rslt_id
216: and pen5.business_group_id = p_business_group_id
217: and pen5.prtt_enrt_rslt_id = pdp_old.prtt_enrt_rslt_id

Line 221: select '1' from ben_elig_cvrd_dpnt_f pdp_old

217: and pen5.prtt_enrt_rslt_id = pdp_old.prtt_enrt_rslt_id
218: and pen5.pl_typ_id in (select pl_typ_id from ben_elig_per_elctbl_chc
219: where elig_per_elctbl_chc_id = p_new_elig_per_elctbl_chc_id)
220: union
221: select '1' from ben_elig_cvrd_dpnt_f pdp_old
222: ,ben_prtt_enrt_rslt_f pen5
223: where pdp_old.per_in_ler_id = ben_manage_life_events.g_bckdt_per_in_ler_id
224: and pdp_old.prtt_enrt_rslt_id <> l_old_prtt_enrt_rslt_id
225: and pdp_old.business_group_id = p_business_group_id

Line 270: from ben_elig_cvrd_dpnt_f ecd

266: and new2.business_group_id = p_business_group_id
267: and new2.dpnt_person_id in
268: -- Make sure that the dpnt being counted was covered before
269: (select dpnt_person_id
270: from ben_elig_cvrd_dpnt_f ecd
271: where prtt_enrt_rslt_id = l_old_prtt_enrt_rslt_id
272: and cvg_strt_dt is not null
273: and nvl(cvg_thru_dt, hr_api.g_eot) >=
274: nvl(pil2.lf_evt_ocrd_dt - 1, hr_api.g_eot)

Line 316: from ben_elig_cvrd_dpnt_f ecd,

312: select ecd.elig_cvrd_dpnt_id,
313: ecd.dpnt_person_id,
314: ecd.elig_per_elctbl_chc_id,
315: ecd.object_version_number
316: from ben_elig_cvrd_dpnt_f ecd,
317: ben_per_in_ler pil
318: where ecd.prtt_enrt_rslt_id = p_new_prtt_enrt_rslt_id
319: and ecd.cvg_strt_dt is not null
320: and nvl(ecd.cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot

Line 345: from ben_elig_cvrd_dpnt_f old,

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