APPS.BEN_MNG_DPNT_BNF dependencies on HR_API

Line 116: and nvl(old.cvg_thru_dt, hr_api.g_eot) >= nvl(pil2.lf_evt_ocrd_dt - 1,

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
116: and nvl(old.cvg_thru_dt, hr_api.g_eot) >= nvl(pil2.lf_evt_ocrd_dt - 1,
117: hr_api.g_eot)
118: and old.business_group_id = p_business_group_id
119: and p_effective_date between old.effective_start_date
120: and old.effective_end_date

Line 117: hr_api.g_eot)

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
116: and nvl(old.cvg_thru_dt, hr_api.g_eot) >= nvl(pil2.lf_evt_ocrd_dt - 1,
117: hr_api.g_eot)
118: and old.business_group_id = p_business_group_id
119: and p_effective_date between old.effective_start_date
120: and old.effective_end_date
121: and new.elig_per_elctbl_chc_id = p_new_elig_per_elctbl_chc_id

Line 144: and nvl(old.cvg_thru_dt, hr_api.g_eot) >= nvl(pil2.lf_evt_ocrd_dt - 1,

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
143: and old.cvg_strt_dt is not null
144: and nvl(old.cvg_thru_dt, hr_api.g_eot) >= nvl(pil2.lf_evt_ocrd_dt - 1,
145: hr_api.g_eot)
146: and old.business_group_id = p_business_group_id
147: and p_effective_date between old.effective_start_date
148: and old.effective_end_date

Line 145: hr_api.g_eot)

141: ben_per_in_ler pil2
142: where old.prtt_enrt_rslt_id = l_old_prtt_enrt_rslt_id
143: and old.cvg_strt_dt is not null
144: and nvl(old.cvg_thru_dt, hr_api.g_eot) >= nvl(pil2.lf_evt_ocrd_dt - 1,
145: hr_api.g_eot)
146: and old.business_group_id = p_business_group_id
147: and p_effective_date between old.effective_start_date
148: and old.effective_end_date
149: and new.elig_per_elctbl_chc_id = p_new_elig_per_elctbl_chc_id

Line 167: and pen1.effective_end_date = hr_api.g_eot

163: ('Y' = (select 'Y' from dual where exists
164: (select '1' from ben_prtt_enrt_rslt_f pen1
165: where pen1.prtt_enrt_rslt_id = p_old_prtt_enrt_rslt_id
166: and pen1.prtt_enrt_rslt_stat_cd is NULL
167: and pen1.effective_end_date = hr_api.g_eot
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

Line 168: and pen1.enrt_cvg_thru_dt = hr_api.g_eot)

164: (select '1' from ben_prtt_enrt_rslt_f pen1
165: where pen1.prtt_enrt_rslt_id = p_old_prtt_enrt_rslt_id
166: and pen1.prtt_enrt_rslt_stat_cd is NULL
167: and pen1.effective_end_date = hr_api.g_eot
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,

Line 170: and old.cvg_thru_dt <> hr_api.g_eot

166: and pen1.prtt_enrt_rslt_stat_cd is NULL
167: and pen1.effective_end_date = hr_api.g_eot
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

Line 201: and pdp_old.cvg_thru_dt <> hr_api.g_eot

197: where pdp_old.per_in_ler_id = ben_manage_life_events.g_bckdt_per_in_ler_id
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

Line 212: and pdp_old.cvg_thru_dt = hr_api.g_eot

208: where pdp_old.per_in_ler_id = ben_manage_life_events.g_bckdt_per_in_ler_id
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

Line 227: and pdp_old.cvg_thru_dt = hr_api.g_eot

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
226: and pdp_old.dpnt_person_id = old.dpnt_person_id
227: and pdp_old.cvg_thru_dt = hr_api.g_eot
228: and pen5.per_in_ler_id = ben_manage_life_events.g_bckdt_per_in_ler_id
229: and pen5.prtt_enrt_rslt_id <> l_old_prtt_enrt_rslt_id
230: and pen5.business_group_id = p_business_group_id
231: and pen5.prtt_enrt_rslt_id = pdp_old.prtt_enrt_rslt_id

Line 273: and nvl(cvg_thru_dt, hr_api.g_eot) >=

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)
275: and business_group_id = p_business_group_id
276: and p_effective_date between effective_start_date
277: and effective_end_date)

Line 274: nvl(pil2.lf_evt_ocrd_dt - 1, hr_api.g_eot)

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)
275: and business_group_id = p_business_group_id
276: and p_effective_date between effective_start_date
277: and effective_end_date)
278: and new2.dpnt_person_id = pcr2.contact_person_id

Line 320: and nvl(ecd.cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot

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
321: and ecd.business_group_id = p_business_group_id
322: and p_effective_date between ecd.effective_start_date
323: and ecd.effective_end_date
324: and pil.per_in_ler_id=ecd.per_in_ler_id

Line 352: and nvl(old.cvg_thru_dt, hr_api.g_eot) >= nvl(pil2.lf_evt_ocrd_dt - 1,

348: ben_per_in_ler pil2,
349: per_contact_relationships pcr
350: where old.prtt_enrt_rslt_id = l_old_prtt_enrt_rslt_id
351: and old.cvg_strt_dt is not null
352: and nvl(old.cvg_thru_dt, hr_api.g_eot) >= nvl(pil2.lf_evt_ocrd_dt - 1,
353: hr_api.g_eot)
354: and old.business_group_id = p_business_group_id
355: and p_effective_date between old.effective_start_date
356: and old.effective_end_date

Line 353: hr_api.g_eot)

349: per_contact_relationships pcr
350: where old.prtt_enrt_rslt_id = l_old_prtt_enrt_rslt_id
351: and old.cvg_strt_dt is not null
352: and nvl(old.cvg_thru_dt, hr_api.g_eot) >= nvl(pil2.lf_evt_ocrd_dt - 1,
353: hr_api.g_eot)
354: and old.business_group_id = p_business_group_id
355: and p_effective_date between old.effective_start_date
356: and old.effective_end_date
357: and new.elig_per_elctbl_chc_id = p_new_elig_per_elctbl_chc_id

Line 932: p_cvg_thru_dt => hr_api.g_eot,

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,
932: p_cvg_thru_dt => hr_api.g_eot,
933: p_datetrack_mode => p_datetrack_mode,
934: p_elig_cvrd_dpnt_id => l_elig_cvrd_dpnt_id,
935: p_effective_start_date => l_effective_start_date,
936: p_effective_end_date => l_effective_end_date,

Line 980: l_datetrack_mode := hr_api.g_update_override;

976: p_update_override => l_update_override,
977: p_update_change_insert => l_update_change_insert);
978: --
979: if l_update_override then
980: l_datetrack_mode := hr_api.g_update_override;
981: elsif l_update then
982: l_datetrack_mode := hr_api.g_update;
983: else
984: l_datetrack_mode := hr_api.g_correction;

Line 982: l_datetrack_mode := hr_api.g_update;

978: --
979: if l_update_override then
980: l_datetrack_mode := hr_api.g_update_override;
981: elsif l_update then
982: l_datetrack_mode := hr_api.g_update;
983: else
984: l_datetrack_mode := hr_api.g_correction;
985: end if;
986: --

Line 984: l_datetrack_mode := hr_api.g_correction;

980: l_datetrack_mode := hr_api.g_update_override;
981: elsif l_update then
982: l_datetrack_mode := hr_api.g_update;
983: else
984: l_datetrack_mode := hr_api.g_correction;
985: end if;
986: --
987: hr_utility.set_location('rtagarra '||l_datetrack_mode,9653);
988: -- Bug 6793512

Line 1025: l_datetrack_mode := hr_api.g_update_override;

1021: p_update_override => l_update_override,
1022: p_update_change_insert => l_update_change_insert);
1023: --
1024: if l_update_override then
1025: l_datetrack_mode := hr_api.g_update_override;
1026: elsif l_update then
1027: l_datetrack_mode := hr_api.g_update;
1028: else
1029: l_datetrack_mode := hr_api.g_correction;

Line 1027: l_datetrack_mode := hr_api.g_update;

1023: --
1024: if l_update_override then
1025: l_datetrack_mode := hr_api.g_update_override;
1026: elsif l_update then
1027: l_datetrack_mode := hr_api.g_update;
1028: else
1029: l_datetrack_mode := hr_api.g_correction;
1030: end if;
1031: --

Line 1029: l_datetrack_mode := hr_api.g_correction;

1025: l_datetrack_mode := hr_api.g_update_override;
1026: elsif l_update then
1027: l_datetrack_mode := hr_api.g_update;
1028: else
1029: l_datetrack_mode := hr_api.g_correction;
1030: end if;
1031: --
1032: hr_utility.set_location('rtagarra '||l_datetrack_mode,9653);
1033: --