eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_DETERMINE_ACTIVITY_BASE_RT dependencies on BEN_DISTRIBUTE_RATES

Line 127: 20-Jan-00 maagrawa 115.47 Pass payroll_id to ben_distribute_rates

123: ann-val-flag is on.
124: 17-Jan-00 tguy 115.46 Added check for rounding when vrbl
125: rt trtmt cd = rplc do not round at
126: value at this level
127: 20-Jan-00 maagrawa 115.47 Pass payroll_id to ben_distribute_rates
128: 20-Jan-00 lmcdonal 115.48 If enrt_bnft cvg val is null, use dflt
129: val. Bug 1118016.
130: 09-FEB-2000 pbodla 115.49 - Bug : 1169626 p_acty_base_rt_id is passed
131: to formula instead of l_acty_base_rt_id

Line 2645: l_val := ben_distribute_rates.estonly_pp_to_period

2641: ,p_calculated_val => l_val);
2642: /* : 1791203: added */
2643: /*
2644: if nvl(l_abr.det_pl_ytd_cntrs_cd,'X') = 'ESTONLY' then
2645: l_val := ben_distribute_rates.estonly_pp_to_period
2646: (p_business_group_id,
2647: p_person_id,
2648: p_effective_date ,
2649: p_acty_base_rt_id,

Line 2782: ben_distribute_rates.periodize_with_rule

2778: --GEVITY
2779: --
2780: IF l_abr.rate_periodization_rl IS NOT NULL THEN
2781: --
2782: ben_distribute_rates.periodize_with_rule
2783: (p_formula_id => l_abr.rate_periodization_rl -- in number,
2784: ,p_effective_date => nvl(p_lf_evt_ocrd_dt,l_effective_date) --in date,
2785: ,p_assignment_id => l_assignment_id --in number,
2786: ,p_convert_from_val => l_coverage_value -- in number,

Line 2804: l_val := ben_distribute_rates.annual_to_period

2800: else
2801: l_element_type_id := null;
2802: end if;
2803: --
2804: l_val := ben_distribute_rates.annual_to_period
2805: (p_amount => p_ann_val,
2806: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
2807: p_acty_ref_perd_cd => l_acty_ref_perd_cd,
2808: p_business_group_id => l_epe.business_group_id,

Line 2823: l_calc_val := ben_distribute_rates.period_to_annual

2819: --
2820: hr_utility.set_location ('BDR_ATP '||l_package,291);
2821: /**************************************/
2822: /* --Bug 2149438
2823: l_calc_val := ben_distribute_rates.period_to_annual
2824: (p_amount => l_val,
2825: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
2826: p_acty_ref_perd_cd => l_acty_ref_perd_cd,
2827: p_business_group_id => l_epe.business_group_id,

Line 2842: p_cmcd_val := ben_distribute_rates.annual_to_period_out

2838: else
2839: l_element_type_id := null;
2840: end if;
2841: --
2842: p_cmcd_val := ben_distribute_rates.annual_to_period_out
2843: (p_amount => l_calc_val,
2844: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
2845: p_acty_ref_perd_cd => l_enrt_info_rt_freq_cd,
2846: p_business_group_id => l_epe.business_group_id,

Line 3368: ben_distribute_rates.periodize_with_rule

3364: else
3365: --GEVITY
3366: IF l_abr.rate_periodization_rl IS NOT NULL THEN
3367: --
3368: ben_distribute_rates.periodize_with_rule
3369: (p_formula_id => l_abr.rate_periodization_rl
3370: ,p_effective_date => nvl(p_lf_evt_ocrd_dt,l_effective_date)
3371: ,p_assignment_id => l_assignment_id
3372: ,p_convert_from_val => l_abr.dflt_val

Line 3385: p_ann_dflt_val := ben_distribute_rates.period_to_annual

3381: );
3382: --
3383: ELSE
3384: --
3385: p_ann_dflt_val := ben_distribute_rates.period_to_annual
3386: (p_amount => l_abr.dflt_val,
3387: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
3388: p_acty_ref_perd_cd => l_acty_ref_perd_cd,
3389: p_business_group_id => l_epe.business_group_id,

Line 3410: ben_distribute_rates.periodize_with_rule

3406: IF l_abr.rate_periodization_rl IS NOT NULL THEN
3407: --
3408: l_dfnd_dummy := p_val ;
3409: --
3410: ben_distribute_rates.periodize_with_rule
3411: (p_formula_id => l_abr.rate_periodization_rl
3412: ,p_effective_date => nvl(p_lf_evt_ocrd_dt,l_effective_date)
3413: ,p_assignment_id => l_assignment_id
3414: ,p_convert_from_val => l_dfnd_dummy

Line 3429: l_ann_val := ben_distribute_rates.period_to_annual

3425: l_dfnd_dummy := NULL ;
3426: --
3427: ELSE
3428: --
3429: l_ann_val := ben_distribute_rates.period_to_annual
3430: (p_amount => p_val,
3431: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
3432: p_acty_ref_perd_cd => l_acty_ref_perd_cd,
3433: p_business_group_id => l_epe.business_group_id,

Line 3440: l_calc_val := ben_distribute_rates.period_to_annual

3436: p_complete_year_flag => 'Y',
3437: p_payroll_id => l_payroll_id);
3438: hr_utility.set_location ('BDR_PTA '||l_package,290);
3439: --
3440: l_calc_val := ben_distribute_rates.period_to_annual
3441: (p_amount => p_val,
3442: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
3443: p_acty_ref_perd_cd => l_acty_ref_perd_cd,
3444: p_business_group_id => l_epe.business_group_id,

Line 3456: l_cmcd_val := ben_distribute_rates.annual_to_period_out

3452: else
3453: l_element_type_id := null;
3454: end if;
3455: --
3456: l_cmcd_val := ben_distribute_rates.annual_to_period_out
3457: (p_amount => l_calc_val,
3458: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
3459: p_acty_ref_perd_cd => l_enrt_info_rt_freq_cd,
3460: p_business_group_id => l_epe.business_group_id,

Line 3478: ben_distribute_rates.prorate_min_max

3474: --Bug 5225815 do not prorate if there are no prior elections
3475: --or the l_rt_strt_dt is null
3476: if l_abr.entr_ann_val_flag = 'Y' and l_rt_strt_dt is not null then
3477: -- Before assigning the annual min and max, try to prorate the values.
3478: ben_distribute_rates.prorate_min_max
3479: (p_person_id => p_person_id
3480: ,p_effective_date => l_effective_date
3481: ,p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id
3482: ,p_acty_base_rt_id => p_acty_base_rt_id

Line 3488: ben_distribute_rates.compare_balances

3484: ,p_ann_mn_val => l_vr_ann_mn_elcn_val
3485: ,p_ann_mx_val => l_vr_ann_mx_elcn_val ) ;
3486: -- Also, check that their period-to-date payments and claims do not
3487: -- force the minimum and maximum to be different.
3488: ben_distribute_rates.compare_balances
3489: (p_person_id => p_person_id
3490: ,p_effective_date => l_effective_date
3491: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
3492: ,p_pgm_id => l_epe.pgm_id

Line 3535: ben_distribute_rates.periodize_with_rule

3531: end if;
3532: --
3533: IF l_abr.rate_periodization_rl IS NOT NULL THEN
3534: --
3535: ben_distribute_rates.periodize_with_rule
3536: (p_formula_id => l_abr.rate_periodization_rl
3537: ,p_effective_date => nvl(p_lf_evt_ocrd_dt,l_effective_date)
3538: ,p_assignment_id => l_assignment_id
3539: ,p_convert_from_val => nvl(l_vr_ann_mn_elcn_val,l_abr.ann_mn_elcn_val)

Line 3552: l_cmcd_mn_val := ben_distribute_rates.annual_to_period

3548: );
3549: --
3550: ELSE
3551: --
3552: l_cmcd_mn_val := ben_distribute_rates.annual_to_period
3553: (p_amount => nvl(l_vr_ann_mn_elcn_val,l_abr.ann_mn_elcn_val),
3554: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
3555: p_acty_ref_perd_cd => l_enrt_info_rt_freq_cd,
3556: p_business_group_id => l_epe.business_group_id,

Line 3569: ben_distribute_rates.periodize_with_rule

3565: if nvl(l_vr_ann_mx_elcn_val,l_abr.ann_mx_elcn_val) is not null then
3566: --GEVITY
3567: IF l_abr.rate_periodization_rl IS NOT NULL THEN
3568: --
3569: ben_distribute_rates.periodize_with_rule
3570: (p_formula_id => l_abr.rate_periodization_rl
3571: ,p_effective_date => nvl(p_lf_evt_ocrd_dt,l_effective_date)
3572: ,p_assignment_id => l_assignment_id
3573: ,p_convert_from_val => nvl(l_vr_ann_mx_elcn_val,l_abr.ann_mx_elcn_val)

Line 3592: l_cmcd_mx_val := ben_distribute_rates.annual_to_period

3588: else
3589: l_element_type_id := null;
3590: end if;
3591: --
3592: l_cmcd_mx_val := ben_distribute_rates.annual_to_period
3593: (p_amount =>nvl(l_vr_ann_mx_elcn_val,l_abr.ann_mx_elcn_val),
3594: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
3595: p_acty_ref_perd_cd => l_enrt_info_rt_freq_cd,
3596: p_business_group_id => l_epe.business_group_id,

Line 3614: ben_distribute_rates.periodize_with_rule

3610: IF l_abr.rate_periodization_rl IS NOT NULL THEN
3611: --
3612: --null;
3613:
3614: ben_distribute_rates.periodize_with_rule
3615: (p_formula_id => l_abr.rate_periodization_rl
3616: ,p_effective_date => nvl(p_lf_evt_ocrd_dt,l_effective_date)
3617: ,p_assignment_id => l_assignment_id
3618: ,p_convert_from_val => p_ann_dflt_val

Line 3639: l_cmcd_dflt_val := ben_distribute_rates.annual_to_period

3635: l_element_type_id := null;
3636: end if;
3637: --
3638: hr_utility.set_location ('HMANI Me here'||l_cmcd_dflt_val,290.3);
3639: l_cmcd_dflt_val := ben_distribute_rates.annual_to_period
3640: (p_amount => p_ann_dflt_val,
3641: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
3642: p_acty_ref_perd_cd => l_enrt_info_rt_freq_cd,
3643: p_business_group_id => l_epe.business_group_id,

Line 3670: ben_distribute_rates.periodize_with_rule

3666: if (nvl(l_vr_mn_elcn_val,l_abr.mn_elcn_val)) is not null then
3667: --GEVITY
3668: IF l_abr.rate_periodization_rl IS NOT NULL THEN
3669: --
3670: ben_distribute_rates.periodize_with_rule
3671: (p_formula_id => l_abr.rate_periodization_rl
3672: ,p_effective_date => nvl(p_lf_evt_ocrd_dt,l_effective_date)
3673: ,p_assignment_id => l_assignment_id
3674: ,p_convert_from_val => nvl(l_vr_mn_elcn_val,l_abr.mn_elcn_val)

Line 3687: l_cmcd_ann_mn_val := ben_distribute_rates.period_to_annual

3683: );
3684: --
3685: ELSE
3686: --
3687: l_cmcd_ann_mn_val := ben_distribute_rates.period_to_annual
3688: (p_amount => nvl(l_vr_mn_elcn_val,l_abr.mn_elcn_val),
3689: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
3690: p_acty_ref_perd_cd => l_acty_ref_perd_cd,
3691: p_business_group_id => l_epe.business_group_id,

Line 3703: l_cmcd_mn_val := ben_distribute_rates.annual_to_period

3699: else
3700: l_element_type_id := null;
3701: end if;
3702: --
3703: l_cmcd_mn_val := ben_distribute_rates.annual_to_period
3704: (p_amount =>l_cmcd_ann_mn_val ,
3705: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
3706: p_acty_ref_perd_cd => l_enrt_info_rt_freq_cd,
3707: p_business_group_id => l_epe.business_group_id,

Line 3721: ben_distribute_rates.periodize_with_rule

3717: if (nvl(l_vr_mx_elcn_val,l_abr.mx_elcn_val)) is not null then
3718: --GEVITY
3719: IF l_abr.rate_periodization_rl IS NOT NULL THEN
3720: --
3721: ben_distribute_rates.periodize_with_rule
3722: (p_formula_id => l_abr.rate_periodization_rl
3723: ,p_effective_date => nvl(p_lf_evt_ocrd_dt,l_effective_date)
3724: ,p_assignment_id => l_assignment_id
3725: ,p_convert_from_val => nvl(l_vr_mx_elcn_val,l_abr.mx_elcn_val)

Line 3739: l_cmcd_ann_mx_val := ben_distribute_rates.period_to_annual

3735: --
3736: ELSE
3737: --
3738: --
3739: l_cmcd_ann_mx_val := ben_distribute_rates.period_to_annual
3740: (p_amount => nvl(l_vr_mx_elcn_val,l_abr.mx_elcn_val),
3741: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
3742: p_acty_ref_perd_cd => l_acty_ref_perd_cd,
3743: p_business_group_id => l_epe.business_group_id,

Line 3756: l_cmcd_mx_val := ben_distribute_rates.annual_to_period

3752: else
3753: l_element_type_id := null;
3754: end if;
3755: --
3756: l_cmcd_mx_val := ben_distribute_rates.annual_to_period
3757: (p_amount =>l_cmcd_ann_mx_val,
3758: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
3759: p_acty_ref_perd_cd => l_enrt_info_rt_freq_cd,
3760: p_business_group_id => l_epe.business_group_id,

Line 3775: ben_distribute_rates.periodize_with_rule

3771: if l_abr.dflt_val is not null then
3772: --GEVITY
3773: IF l_abr.rate_periodization_rl IS NOT NULL THEN
3774: --
3775: ben_distribute_rates.periodize_with_rule
3776: (p_formula_id => l_abr.rate_periodization_rl
3777: ,p_effective_date => nvl(p_lf_evt_ocrd_dt,l_effective_date)
3778: ,p_assignment_id => l_assignment_id
3779: ,p_convert_from_val => l_abr.dflt_val

Line 3793: l_cmcd_ann_dflt_val := ben_distribute_rates.period_to_annual

3789: --
3790: ELSE
3791: --
3792: --
3793: l_cmcd_ann_dflt_val := ben_distribute_rates.period_to_annual
3794: (p_amount => l_abr.dflt_val,
3795: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
3796: p_acty_ref_perd_cd => l_acty_ref_perd_cd,
3797: p_business_group_id => l_epe.business_group_id,

Line 3810: l_cmcd_dflt_val := ben_distribute_rates.annual_to_period

3806: else
3807: l_element_type_id := null;
3808: end if;
3809: --
3810: l_cmcd_dflt_val := ben_distribute_rates.annual_to_period
3811: (p_amount =>l_cmcd_ann_dflt_val,
3812: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
3813: p_acty_ref_perd_cd => l_enrt_info_rt_freq_cd,
3814: p_business_group_id => l_epe.business_group_id,

Line 4280: ben_distribute_rates.periodize_with_rule

4276: --
4277: --GEVITY
4278: IF l_rate_periodization_rl IS NOT NULL THEN
4279: --
4280: ben_distribute_rates.periodize_with_rule
4281: (p_formula_id => l_rate_periodization_rl
4282: ,p_effective_date => l_effective_date
4283: ,p_assignment_id => l_assignment_id
4284: ,p_convert_from_val => p_bnft_amt

Line 4301: p_cmcd_val := ben_distribute_rates.annual_to_period

4297: open c_rt_strt_dt(l_enrt_rt.enrt_rt_id);
4298: fetch c_rt_strt_dt into l_rt_strt_dt;
4299: close c_rt_strt_dt;
4300: --
4301: p_cmcd_val := ben_distribute_rates.annual_to_period
4302: (p_amount => p_bnft_amt,
4303: p_enrt_rt_id => l_enrt_rt.enrt_rt_id,
4304: p_acty_ref_perd_cd => l_enrt_rt.cmcd_acty_ref_perd_cd,
4305: p_business_group_id => p_business_group_id,