APPS.BEN_PROC_COMMON_ENRT_RSLT dependencies on HR_API

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

170: from ben_prtt_enrt_rslt_f pen
171: where pen.per_in_ler_id = p_per_in_ler_id
172: and pen.pgm_id = p_pgm_id
173: and pen.prtt_enrt_rslt_stat_cd is null
174: and pen.enrt_cvg_thru_dt = hr_api.g_eot ;
175: --Bug 4414127
176: cursor c_pl_elcns_made_dt is
177: select max(pen.EFFECTIVE_START_DATE) elcns_made_dt
178: from ben_prtt_enrt_rslt_f pen

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.pl_id = p_pl_id
181: and pen.prtt_enrt_rslt_stat_cd is null
182: and pen.enrt_cvg_thru_dt = hr_api.g_eot ;
183: --
184: l_old_elcns_made_dt date default null;
185: l_new_elcns_made_dt date default null;
186: --

Line 370: and enrt_cvg_thru_dt = hr_api.g_eot

366: or pen.enrt_mthd_cd = 'O'
367: or pen.enrt_mthd_cd = 'D') --7447088
368: and pen.prtt_enrt_rslt_stat_cd is null
369: --and pen.per_in_ler_id = c_per_in_ler_id
370: and enrt_cvg_thru_dt = hr_api.g_eot
371: and pen.comp_lvl_cd <> 'PLANIMP'
372: and pen.prtt_enrt_rslt_id = enb.prtt_enrt_rslt_id
373: and enb.cvg_mlt_cd = 'ERL'
374: and c_effective_date

Line 376: and pen.effective_end_date = hr_api.g_eot

372: and pen.prtt_enrt_rslt_id = enb.prtt_enrt_rslt_id
373: and enb.cvg_mlt_cd = 'ERL'
374: and c_effective_date
375: between pen.effective_start_date and pen.effective_end_date
376: and pen.effective_end_date = hr_api.g_eot
377: and enb.elig_per_elctbl_chc_id = epe.elig_per_elctbl_chc_id
378: and epe.per_in_ler_id = c_per_in_ler_id
379: ;
380: --

Line 429: AND pen.enrt_cvg_thru_dt = hr_api.g_eot

425: WHERE pen.rplcs_sspndd_rslt_id = c_interim_pen
426: AND pen.person_id = c_person_id
427: AND pen.prtt_enrt_rslt_stat_cd IS NULL
428: AND pen.per_in_ler_id = c_per_in_ler_id
429: AND pen.enrt_cvg_thru_dt = hr_api.g_eot
430: AND c_effective_date BETWEEN pen.effective_start_date
431: AND pen.effective_end_date
432: AND pen.effective_end_date = hr_api.g_eot;
433: --

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

428: AND pen.per_in_ler_id = c_per_in_ler_id
429: AND pen.enrt_cvg_thru_dt = hr_api.g_eot
430: AND c_effective_date BETWEEN pen.effective_start_date
431: AND pen.effective_end_date
432: AND pen.effective_end_date = hr_api.g_eot;
433: --
434: l_interim varchar2(30) ;
435: l_suspended_pen_id number;
436: l_suspended_ovn number;

Line 685: p_datetrack_mode => hr_api.g_update,

681: p_pen_attribute27 => l_enrt_rslt.pen_attribute27,
682: p_pen_attribute28 => l_enrt_rslt.pen_attribute28,
683: p_pen_attribute29 => l_enrt_rslt.pen_attribute29,
684: p_pen_attribute30 => l_enrt_rslt.pen_attribute30,
685: p_datetrack_mode => hr_api.g_update,
686: p_suspend_flag => l_dummy_char,
687: p_effective_start_date => l_dummy_date,
688: p_effective_end_date => l_dummy_date,
689: p_object_version_number => l_enrt_rslt.object_version_number,

Line 752: ,P_desired_datetrack_mode => hr_api.g_correction

748: --
749: ben_prtt_enrt_result_api.get_ben_pen_upd_dt_mode
750: (p_effective_date => p_effective_date
751: ,p_base_key_value => l_suspended_pen_id
752: ,P_desired_datetrack_mode => hr_api.g_correction
753: ,P_datetrack_allow => l_datetrack_mode
754: );
755: --
756: hr_utility.set_location('After ERL Interim call BEPENDT',20);