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 = p_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 = p_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 = p_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 = p_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 188: and nvl(cvg_thru_dt, hr_api.g_eot) >=

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)
190: and business_group_id = p_business_group_id
191: and p_effective_date between effective_start_date
192: and effective_end_date)

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

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)
190: and business_group_id = p_business_group_id
191: and p_effective_date between effective_start_date
192: and effective_end_date)
193: and new2.dpnt_person_id = pcr2.contact_person_id

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

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
236: and ecd.business_group_id = p_business_group_id
237: and p_effective_date between ecd.effective_start_date
238: and ecd.effective_end_date
239: and pil.per_in_ler_id=ecd.per_in_ler_id

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

263: ben_per_in_ler pil2,
264: per_contact_relationships pcr
265: where old.prtt_enrt_rslt_id = p_old_prtt_enrt_rslt_id
266: and old.cvg_strt_dt is not null
267: and nvl(old.cvg_thru_dt, hr_api.g_eot) >= nvl(pil2.lf_evt_ocrd_dt - 1,
268: hr_api.g_eot)
269: and old.business_group_id = p_business_group_id
270: and p_effective_date between old.effective_start_date
271: and old.effective_end_date

Line 268: hr_api.g_eot)

264: per_contact_relationships pcr
265: where old.prtt_enrt_rslt_id = p_old_prtt_enrt_rslt_id
266: and old.cvg_strt_dt is not null
267: and nvl(old.cvg_thru_dt, hr_api.g_eot) >= nvl(pil2.lf_evt_ocrd_dt - 1,
268: hr_api.g_eot)
269: and old.business_group_id = p_business_group_id
270: and p_effective_date between old.effective_start_date
271: and old.effective_end_date
272: and new.elig_per_elctbl_chc_id = p_new_elig_per_elctbl_chc_id

Line 784: p_cvg_thru_dt => hr_api.g_eot,

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,
784: p_cvg_thru_dt => hr_api.g_eot,
785: p_datetrack_mode => p_datetrack_mode,
786: p_elig_cvrd_dpnt_id => l_elig_cvrd_dpnt_id,
787: p_effective_start_date => l_effective_start_date,
788: p_effective_end_date => l_effective_end_date,

Line 827: l_datetrack_mode := hr_api.g_update_override;

823: p_update_override => l_update_override,
824: p_update_change_insert => l_update_change_insert);
825: --
826: if l_update_override then
827: l_datetrack_mode := hr_api.g_update_override;
828: elsif l_update then
829: l_datetrack_mode := hr_api.g_update;
830: else
831: l_datetrack_mode := hr_api.g_correction;

Line 829: l_datetrack_mode := hr_api.g_update;

825: --
826: if l_update_override then
827: l_datetrack_mode := hr_api.g_update_override;
828: elsif l_update then
829: l_datetrack_mode := hr_api.g_update;
830: else
831: l_datetrack_mode := hr_api.g_correction;
832: end if;
833: --

Line 831: l_datetrack_mode := hr_api.g_correction;

827: l_datetrack_mode := hr_api.g_update_override;
828: elsif l_update then
829: l_datetrack_mode := hr_api.g_update;
830: else
831: l_datetrack_mode := hr_api.g_correction;
832: end if;
833: --
834: hr_utility.set_location('rtagarra '||l_datetrack_mode,9653);
835: -- Bug 6793512

Line 872: l_datetrack_mode := hr_api.g_update_override;

868: p_update_override => l_update_override,
869: p_update_change_insert => l_update_change_insert);
870: --
871: if l_update_override then
872: l_datetrack_mode := hr_api.g_update_override;
873: elsif l_update then
874: l_datetrack_mode := hr_api.g_update;
875: else
876: l_datetrack_mode := hr_api.g_correction;

Line 874: l_datetrack_mode := hr_api.g_update;

870: --
871: if l_update_override then
872: l_datetrack_mode := hr_api.g_update_override;
873: elsif l_update then
874: l_datetrack_mode := hr_api.g_update;
875: else
876: l_datetrack_mode := hr_api.g_correction;
877: end if;
878: --

Line 876: l_datetrack_mode := hr_api.g_correction;

872: l_datetrack_mode := hr_api.g_update_override;
873: elsif l_update then
874: l_datetrack_mode := hr_api.g_update;
875: else
876: l_datetrack_mode := hr_api.g_correction;
877: end if;
878: --
879: hr_utility.set_location('rtagarra '||l_datetrack_mode,9653);
880: --