APPS.BEN_DETERMINE_ACTIVITY_BASE_RT dependencies on HR_API

Line 963: and pen.effective_end_date = hr_api.g_eot

959: -- result past the life event occured date
960: --and c_effective_date
961: -- between pen.effective_start_date
962: -- and pen.effective_end_date
963: and pen.effective_end_date = hr_api.g_eot
964: and ((c_effective_date <= prv.rt_end_dt) or (prv.rt_strt_dt = prv.rt_end_dt))
965: --RCHASE end
966: order by prv.rt_strt_dt desc; -- 5748126 Changed ORDER-BY from ASC to DESC
967:

Line 992: and pen.effective_end_date = hr_api.g_eot

988: and pen.prtt_enrt_rslt_stat_cd is null
989: and prv.prtt_rt_val_stat_cd is null
990: and prv.acty_base_rt_id = c_acty_base_rt_id
991: and c_effective_date < pen.enrt_cvg_thru_dt
992: and pen.effective_end_date = hr_api.g_eot
993: and ((c_effective_date <= prv.rt_end_dt) or (prv.rt_strt_dt = prv.rt_end_dt))
994: order by prv.rt_strt_dt desc; -- 5748126 Changed ORDER-BY from ASC to DESC
995:
996:

Line 1039: and c_nvlopt_id=hr_api.g_number;

1035: between ep.effective_start_date and ep.effective_end_date
1036: and pil.per_in_ler_id(+) = ep.per_in_ler_id
1037: and ( pil.per_in_ler_stat_cd not in ('VOIDD', 'BCKDT')
1038: or pil.per_in_ler_stat_cd is null)
1039: and c_nvlopt_id=hr_api.g_number;
1040:
1041: cursor c_enrt_prem(p_actl_prem_id in number)
1042: is
1043: select ecr.val

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

2824: elsif l_abr.rt_mlt_cd = 'SAREC' then
2825: hr_utility.set_location ('BDR_ATP '||l_package||to_char(l_coverage_value),299);
2826: --ikasire -- not passing the p_complete_year_flag per bug 1650517
2827: /* Bug 6015724 */
2828: if l_rt_ovridn_flag = 'Y' and nvl(l_rt_ovridn_thru_dt, hr_api.g_eot) >= l_effective_date then
2829: --
2830: p_ann_val:= l_ann_rt_val; -- ikasire
2831: p_val := l_rt_val;
2832: p_cmcd_val := l_cmcd_rt_val;

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

3311: --
3312: -- Start 6015724
3313: --
3314: if l_rt_ovridn_flag = 'Y' and
3315: nvl(l_rt_ovridn_thru_dt, hr_api.g_eot) >= l_effective_date and-- p_effective_date then
3316: l_rt_val = l_val then --bug 13013980
3317: p_val := l_rt_val;
3318: end if;
3319: --

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

3327: -- Bug 2677804 use l_effective_date to handle open enrollment also
3328: if p_calc_only_rt_val_flag then
3329: /* 6015724 - Commenting out this code as we are already doing this calculation before now
3330: if l_rt_ovridn_flag = 'Y' and
3331: nvl(l_rt_ovridn_thru_dt, hr_api.g_eot) >= l_effective_date then -- p_effective_date then
3332: p_val := l_rt_val;
3333: end if; */
3334: return;
3335: end if;

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

3364: (c_person_id => p_person_id
3365: ,c_pl_id => l_epe.pl_id
3366: ,c_pgm_id => nvl(l_epe.pgm_id,-1)
3367: ,c_opt_id => l_opt.opt_id
3368: ,c_nvlopt_id => nvl(l_opt.opt_id,hr_api.g_number)
3369: ,c_effective_date => l_effective_date
3370: );
3371: fetch c_current_elig into l_prtn_strt_dt;
3372: close c_current_elig;

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

4224:
4225: /* Bg 6015724 : Shifting this code part above
4226: --Bug 2677804. Use l_effective_date to resolve the open enrollment issue.
4227: if l_rt_ovridn_flag = 'Y' and
4228: nvl(l_rt_ovridn_thru_dt, hr_api.g_eot) >= l_effective_date then -- p_effective_date then
4229: p_val := l_rt_val;
4230: end if;
4231: */
4232: