APPS.BEN_DETERMINE_ACTIVITY_BASE_RT dependencies on HR_API

Line 946: and pen.effective_end_date = hr_api.g_eot

942: -- result past the life event occured date
943: --and c_effective_date
944: -- between pen.effective_start_date
945: -- and pen.effective_end_date
946: and pen.effective_end_date = hr_api.g_eot
947: and ((c_effective_date <= prv.rt_end_dt) or (prv.rt_strt_dt = prv.rt_end_dt))
948: --RCHASE end
949: order by prv.rt_strt_dt desc; -- 5748126 Changed ORDER-BY from ASC to DESC
950:

Line 975: and pen.effective_end_date = hr_api.g_eot

971: and pen.prtt_enrt_rslt_stat_cd is null
972: and prv.prtt_rt_val_stat_cd is null
973: and prv.acty_base_rt_id = c_acty_base_rt_id
974: and c_effective_date < pen.enrt_cvg_thru_dt
975: and pen.effective_end_date = hr_api.g_eot
976: and ((c_effective_date <= prv.rt_end_dt) or (prv.rt_strt_dt = prv.rt_end_dt))
977: order by prv.rt_strt_dt desc; -- 5748126 Changed ORDER-BY from ASC to DESC
978:
979:

Line 1022: and c_nvlopt_id=hr_api.g_number;

1018: between ep.effective_start_date and ep.effective_end_date
1019: and pil.per_in_ler_id(+) = ep.per_in_ler_id
1020: and ( pil.per_in_ler_stat_cd not in ('VOIDD', 'BCKDT')
1021: or pil.per_in_ler_stat_cd is null)
1022: and c_nvlopt_id=hr_api.g_number;
1023:
1024: cursor c_enrt_prem(p_actl_prem_id in number)
1025: is
1026: select ecr.val

Line 2768: if l_rt_ovridn_flag = 'Y' and nvl(l_rt_ovridn_thru_dt, hr_api.g_eot) >= l_effective_date then

2764: elsif l_abr.rt_mlt_cd = 'SAREC' then
2765: hr_utility.set_location ('BDR_ATP '||l_package||to_char(l_coverage_value),299);
2766: --ikasire -- not passing the p_complete_year_flag per bug 1650517
2767: /* Bug 6015724 */
2768: if l_rt_ovridn_flag = 'Y' and nvl(l_rt_ovridn_thru_dt, hr_api.g_eot) >= l_effective_date then
2769: --
2770: p_ann_val:= l_ann_rt_val; -- ikasire
2771: p_val := l_rt_val;
2772: p_cmcd_val := l_cmcd_rt_val;

Line 3196: nvl(l_rt_ovridn_thru_dt, hr_api.g_eot) >= l_effective_date then -- p_effective_date then

3192: --
3193: -- Start 6015724
3194: --
3195: if l_rt_ovridn_flag = 'Y' and
3196: nvl(l_rt_ovridn_thru_dt, hr_api.g_eot) >= l_effective_date then -- p_effective_date then
3197: p_val := l_rt_val;
3198: end if;
3199: --
3200: -- End 6015724

Line 3211: nvl(l_rt_ovridn_thru_dt, hr_api.g_eot) >= l_effective_date then -- p_effective_date then

3207: -- Bug 2677804 use l_effective_date to handle open enrollment also
3208: if p_calc_only_rt_val_flag then
3209: /* 6015724 - Commenting out this code as we are already doing this calculation before now
3210: if l_rt_ovridn_flag = 'Y' and
3211: nvl(l_rt_ovridn_thru_dt, hr_api.g_eot) >= l_effective_date then -- p_effective_date then
3212: p_val := l_rt_val;
3213: end if; */
3214: return;
3215: end if;

Line 3248: ,c_nvlopt_id => nvl(l_opt.opt_id,hr_api.g_number)

3244: (c_person_id => p_person_id
3245: ,c_pl_id => l_epe.pl_id
3246: ,c_pgm_id => nvl(l_epe.pgm_id,-1)
3247: ,c_opt_id => l_opt.opt_id
3248: ,c_nvlopt_id => nvl(l_opt.opt_id,hr_api.g_number)
3249: ,c_effective_date => l_effective_date
3250: );
3251: fetch c_current_elig into l_prtn_strt_dt;
3252: close c_current_elig;

Line 4029: nvl(l_rt_ovridn_thru_dt, hr_api.g_eot) >= l_effective_date then -- p_effective_date then

4025:
4026: /* Bg 6015724 : Shifting this code part above
4027: --Bug 2677804. Use l_effective_date to resolve the open enrollment issue.
4028: if l_rt_ovridn_flag = 'Y' and
4029: nvl(l_rt_ovridn_thru_dt, hr_api.g_eot) >= l_effective_date then -- p_effective_date then
4030: p_val := l_rt_val;
4031: end if;
4032: */
4033: