APPS.BEN_PROC_COMMON_ENRT_RSLT dependencies on HR_API

Line 182: and pen.enrt_cvg_thru_dt = hr_api.g_eot

178: from ben_prtt_enrt_rslt_f pen
179: where pen.per_in_ler_id = p_per_in_ler_id
180: and pen.pgm_id = p_pgm_id
181: and pen.prtt_enrt_rslt_stat_cd is null
182: and pen.enrt_cvg_thru_dt = hr_api.g_eot
183: and pen.comp_lvl_cd <> 'PLANIMP'; -- Bug 13367099
184: --Bug 4414127
185: cursor c_pl_elcns_made_dt is
186: select max(pen.EFFECTIVE_START_DATE) elcns_made_dt

Line 191: and pen.enrt_cvg_thru_dt = hr_api.g_eot ;

187: from ben_prtt_enrt_rslt_f pen
188: where pen.per_in_ler_id = p_per_in_ler_id
189: and pen.pl_id = p_pl_id
190: and pen.prtt_enrt_rslt_stat_cd is null
191: and pen.enrt_cvg_thru_dt = hr_api.g_eot ;
192: --
193: l_old_elcns_made_dt date default null;
194: l_new_elcns_made_dt date default null;
195: --

Line 385: and enrt_cvg_thru_dt = hr_api.g_eot

381: and epe.elctbl_flag = 'Y')
382: or (pen.per_in_ler_id <> c_per_in_ler_id
383: and epe.elctbl_flag = 'N'))
384: /* end 9026755 */
385: and enrt_cvg_thru_dt = hr_api.g_eot
386: and pen.comp_lvl_cd <> 'PLANIMP'
387: and pen.prtt_enrt_rslt_id = enb.prtt_enrt_rslt_id
388: and enb.cvg_mlt_cd = 'ERL'
389: and c_effective_date

Line 391: and pen.effective_end_date = hr_api.g_eot

387: and pen.prtt_enrt_rslt_id = enb.prtt_enrt_rslt_id
388: and enb.cvg_mlt_cd = 'ERL'
389: and c_effective_date
390: between pen.effective_start_date and pen.effective_end_date
391: and pen.effective_end_date = hr_api.g_eot
392: and enb.elig_per_elctbl_chc_id = epe.elig_per_elctbl_chc_id
393: and epe.per_in_ler_id = c_per_in_ler_id
394: ;
395: --

Line 444: AND pen.enrt_cvg_thru_dt = hr_api.g_eot

440: WHERE pen.rplcs_sspndd_rslt_id = c_interim_pen
441: AND pen.person_id = c_person_id
442: AND pen.prtt_enrt_rslt_stat_cd IS NULL
443: AND pen.per_in_ler_id = c_per_in_ler_id
444: AND pen.enrt_cvg_thru_dt = hr_api.g_eot
445: AND c_effective_date BETWEEN pen.effective_start_date
446: AND pen.effective_end_date
447: AND pen.effective_end_date = hr_api.g_eot;
448: --

Line 447: AND pen.effective_end_date = hr_api.g_eot;

443: AND pen.per_in_ler_id = c_per_in_ler_id
444: AND pen.enrt_cvg_thru_dt = hr_api.g_eot
445: AND c_effective_date BETWEEN pen.effective_start_date
446: AND pen.effective_end_date
447: AND pen.effective_end_date = hr_api.g_eot;
448: --
449: l_interim varchar2(30) ;
450: l_suspended_pen_id number;
451: l_suspended_ovn number;

Line 700: p_datetrack_mode => hr_api.g_update,

696: p_pen_attribute27 => l_enrt_rslt.pen_attribute27,
697: p_pen_attribute28 => l_enrt_rslt.pen_attribute28,
698: p_pen_attribute29 => l_enrt_rslt.pen_attribute29,
699: p_pen_attribute30 => l_enrt_rslt.pen_attribute30,
700: p_datetrack_mode => hr_api.g_update,
701: p_suspend_flag => l_dummy_char,
702: p_effective_start_date => l_dummy_date,
703: p_effective_end_date => l_dummy_date,
704: p_object_version_number => l_enrt_rslt.object_version_number,

Line 767: ,P_desired_datetrack_mode => hr_api.g_correction

763: --
764: ben_prtt_enrt_result_api.get_ben_pen_upd_dt_mode
765: (p_effective_date => p_effective_date
766: ,p_base_key_value => l_suspended_pen_id
767: ,P_desired_datetrack_mode => hr_api.g_correction
768: ,P_datetrack_allow => l_datetrack_mode
769: );
770: --
771: hr_utility.set_location('After ERL Interim call BEPENDT',20);