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 2705: l_val := ben_distribute_rates.estonly_pp_to_period

2701: ,p_calculated_val => l_val);
2702: /* : 1791203: added */
2703: /*
2704: if nvl(l_abr.det_pl_ytd_cntrs_cd,'X') = 'ESTONLY' then
2705: l_val := ben_distribute_rates.estonly_pp_to_period
2706: (p_business_group_id,
2707: p_person_id,
2708: p_effective_date ,
2709: p_acty_base_rt_id,

Line 2842: ben_distribute_rates.periodize_with_rule

2838: --GEVITY
2839: --
2840: IF l_abr.rate_periodization_rl IS NOT NULL THEN
2841: --
2842: ben_distribute_rates.periodize_with_rule
2843: (p_formula_id => l_abr.rate_periodization_rl -- in number,
2844: ,p_effective_date => nvl(p_lf_evt_ocrd_dt,l_effective_date) --in date,
2845: ,p_assignment_id => l_assignment_id --in number,
2846: ,p_convert_from_val => l_coverage_value -- in number,

Line 2898: l_val := ben_distribute_rates.annual_to_period

2894: end if;
2895: hr_utility.set_location ('l_complete_year_flag '||l_complete_year_flag,291);
2896: -- end 14751721
2897: --
2898: l_val := ben_distribute_rates.annual_to_period
2899: (p_amount => p_ann_val,
2900: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
2901: p_acty_ref_perd_cd => l_acty_ref_perd_cd,
2902: p_business_group_id => l_epe.business_group_id,

Line 2918: l_calc_val := ben_distribute_rates.period_to_annual

2914: --
2915: hr_utility.set_location ('BDR_ATP '||l_package,291);
2916: /**************************************/
2917: /* --Bug 2149438
2918: l_calc_val := ben_distribute_rates.period_to_annual
2919: (p_amount => l_val,
2920: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
2921: p_acty_ref_perd_cd => l_acty_ref_perd_cd,
2922: p_business_group_id => l_epe.business_group_id,

Line 2937: p_cmcd_val := ben_distribute_rates.annual_to_period_out

2933: else
2934: l_element_type_id := null;
2935: end if;
2936: --
2937: p_cmcd_val := ben_distribute_rates.annual_to_period_out
2938: (p_amount => l_calc_val,
2939: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
2940: p_acty_ref_perd_cd => l_enrt_info_rt_freq_cd,
2941: p_business_group_id => l_epe.business_group_id,

Line 3488: ben_distribute_rates.periodize_with_rule

3484: else
3485: --GEVITY
3486: IF l_abr.rate_periodization_rl IS NOT NULL THEN
3487: --
3488: ben_distribute_rates.periodize_with_rule
3489: (p_formula_id => l_abr.rate_periodization_rl
3490: ,p_effective_date => nvl(p_lf_evt_ocrd_dt,l_effective_date)
3491: ,p_assignment_id => l_assignment_id
3492: ,p_convert_from_val => l_abr.dflt_val

Line 3505: p_ann_dflt_val := ben_distribute_rates.period_to_annual

3501: );
3502: --
3503: ELSE
3504: --
3505: p_ann_dflt_val := ben_distribute_rates.period_to_annual
3506: (p_amount => l_abr.dflt_val,
3507: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
3508: p_acty_ref_perd_cd => l_acty_ref_perd_cd,
3509: p_business_group_id => l_epe.business_group_id,

Line 3530: ben_distribute_rates.periodize_with_rule

3526: IF l_abr.rate_periodization_rl IS NOT NULL THEN
3527: --
3528: l_dfnd_dummy := p_val ;
3529: --
3530: ben_distribute_rates.periodize_with_rule
3531: (p_formula_id => l_abr.rate_periodization_rl
3532: ,p_effective_date => nvl(p_lf_evt_ocrd_dt,l_effective_date)
3533: ,p_assignment_id => l_assignment_id
3534: ,p_convert_from_val => l_dfnd_dummy

Line 3549: l_ann_val := ben_distribute_rates.period_to_annual

3545: l_dfnd_dummy := NULL ;
3546: --
3547: ELSE
3548: --
3549: l_ann_val := ben_distribute_rates.period_to_annual
3550: (p_amount => p_val,
3551: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
3552: p_acty_ref_perd_cd => l_acty_ref_perd_cd,
3553: p_business_group_id => l_epe.business_group_id,

Line 3560: l_calc_val := ben_distribute_rates.period_to_annual

3556: p_complete_year_flag => 'Y',
3557: p_payroll_id => l_payroll_id);
3558: hr_utility.set_location ('BDR_PTA '||l_package,290);
3559: --
3560: l_calc_val := ben_distribute_rates.period_to_annual
3561: (p_amount => p_val,
3562: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
3563: p_acty_ref_perd_cd => l_acty_ref_perd_cd,
3564: p_business_group_id => l_epe.business_group_id,

Line 3576: l_cmcd_val := ben_distribute_rates.annual_to_period_out

3572: else
3573: l_element_type_id := null;
3574: end if;
3575: --
3576: l_cmcd_val := ben_distribute_rates.annual_to_period_out
3577: (p_amount => l_calc_val,
3578: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
3579: p_acty_ref_perd_cd => l_enrt_info_rt_freq_cd,
3580: p_business_group_id => l_epe.business_group_id,

Line 3598: ben_distribute_rates.prorate_min_max

3594: --Bug 5225815 do not prorate if there are no prior elections
3595: --or the l_rt_strt_dt is null
3596: if l_abr.entr_ann_val_flag = 'Y' and l_rt_strt_dt is not null then
3597: -- Before assigning the annual min and max, try to prorate the values.
3598: ben_distribute_rates.prorate_min_max
3599: (p_person_id => p_person_id
3600: ,p_effective_date => l_effective_date
3601: ,p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id
3602: ,p_acty_base_rt_id => p_acty_base_rt_id

Line 3608: ben_distribute_rates.compare_balances

3604: ,p_ann_mn_val => l_vr_ann_mn_elcn_val
3605: ,p_ann_mx_val => l_vr_ann_mx_elcn_val ) ;
3606: -- Also, check that their period-to-date payments and claims do not
3607: -- force the minimum and maximum to be different.
3608: ben_distribute_rates.compare_balances
3609: (p_person_id => p_person_id
3610: ,p_effective_date => l_effective_date
3611: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
3612: ,p_pgm_id => l_epe.pgm_id

Line 3647: l_cmcd_ann_mn_val := ben_distribute_rates.period_to_annual

3643: --commmunicated values.
3644:
3645: if (l_abr.entr_val_at_enrt_flag = 'N' and l_vapro_entr_val_at_enrt_flag = 'Y') then
3646: if(l_vr_mn_elcn_val is not null and l_vr_mx_elcn_val is not null) then
3647: l_cmcd_ann_mn_val := ben_distribute_rates.period_to_annual
3648: (p_amount => l_vr_mn_elcn_val,
3649: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
3650: p_acty_ref_perd_cd => l_acty_ref_perd_cd,
3651: p_business_group_id => l_epe.business_group_id,

Line 3663: l_cmcd_mn_val := ben_distribute_rates.annual_to_period

3659: else
3660: l_element_type_id := null;
3661: end if;
3662: --
3663: l_cmcd_mn_val := ben_distribute_rates.annual_to_period
3664: (p_amount =>l_cmcd_ann_mn_val ,
3665: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
3666: p_acty_ref_perd_cd => l_enrt_info_rt_freq_cd,
3667: p_business_group_id => l_epe.business_group_id,

Line 3674: l_cmcd_ann_mx_val := ben_distribute_rates.period_to_annual

3670: p_complete_year_flag => 'Y',
3671: p_payroll_id => l_payroll_id,
3672: p_element_type_id => l_element_type_id);
3673:
3674: l_cmcd_ann_mx_val := ben_distribute_rates.period_to_annual
3675: (p_amount => l_vr_mx_elcn_val,
3676: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
3677: p_acty_ref_perd_cd => l_acty_ref_perd_cd,
3678: p_business_group_id => l_epe.business_group_id,

Line 3690: l_cmcd_mx_val := ben_distribute_rates.annual_to_period

3686: else
3687: l_element_type_id := null;
3688: end if;
3689: --
3690: l_cmcd_mx_val := ben_distribute_rates.annual_to_period
3691: (p_amount =>l_cmcd_ann_mx_val ,
3692: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
3693: p_acty_ref_perd_cd => l_enrt_info_rt_freq_cd,
3694: p_business_group_id => l_epe.business_group_id,

Line 3731: ben_distribute_rates.periodize_with_rule

3727: end if;
3728: --
3729: IF l_abr.rate_periodization_rl IS NOT NULL THEN
3730: --
3731: ben_distribute_rates.periodize_with_rule
3732: (p_formula_id => l_abr.rate_periodization_rl
3733: ,p_effective_date => nvl(p_lf_evt_ocrd_dt,l_effective_date)
3734: ,p_assignment_id => l_assignment_id
3735: ,p_convert_from_val => nvl(l_vr_ann_mn_elcn_val,l_abr.ann_mn_elcn_val)

Line 3748: l_cmcd_mn_val := ben_distribute_rates.annual_to_period

3744: );
3745: --
3746: ELSE
3747: --
3748: l_cmcd_mn_val := ben_distribute_rates.annual_to_period
3749: (p_amount => nvl(l_vr_ann_mn_elcn_val,l_abr.ann_mn_elcn_val),
3750: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
3751: p_acty_ref_perd_cd => l_enrt_info_rt_freq_cd,
3752: p_business_group_id => l_epe.business_group_id,

Line 3766: ben_distribute_rates.periodize_with_rule

3762: if nvl(l_vr_ann_mx_elcn_val,l_abr.ann_mx_elcn_val) is not null then
3763: --GEVITY
3764: IF l_abr.rate_periodization_rl IS NOT NULL THEN
3765: --
3766: ben_distribute_rates.periodize_with_rule
3767: (p_formula_id => l_abr.rate_periodization_rl
3768: ,p_effective_date => nvl(p_lf_evt_ocrd_dt,l_effective_date)
3769: ,p_assignment_id => l_assignment_id
3770: ,p_convert_from_val => nvl(l_vr_ann_mx_elcn_val,l_abr.ann_mx_elcn_val)

Line 3789: l_cmcd_mx_val := ben_distribute_rates.annual_to_period

3785: else
3786: l_element_type_id := null;
3787: end if;
3788: --
3789: l_cmcd_mx_val := ben_distribute_rates.annual_to_period
3790: (p_amount =>nvl(l_vr_ann_mx_elcn_val,l_abr.ann_mx_elcn_val),
3791: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
3792: p_acty_ref_perd_cd => l_enrt_info_rt_freq_cd,
3793: p_business_group_id => l_epe.business_group_id,

Line 3812: ben_distribute_rates.periodize_with_rule

3808: IF l_abr.rate_periodization_rl IS NOT NULL THEN
3809: --
3810: --null;
3811:
3812: ben_distribute_rates.periodize_with_rule
3813: (p_formula_id => l_abr.rate_periodization_rl
3814: ,p_effective_date => nvl(p_lf_evt_ocrd_dt,l_effective_date)
3815: ,p_assignment_id => l_assignment_id
3816: ,p_convert_from_val => p_ann_dflt_val

Line 3837: l_cmcd_dflt_val := ben_distribute_rates.annual_to_period

3833: l_element_type_id := null;
3834: end if;
3835: --
3836: hr_utility.set_location ('HMANI Me here'||l_cmcd_dflt_val,290.3);
3837: l_cmcd_dflt_val := ben_distribute_rates.annual_to_period
3838: (p_amount => p_ann_dflt_val,
3839: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
3840: p_acty_ref_perd_cd => l_enrt_info_rt_freq_cd,
3841: p_business_group_id => l_epe.business_group_id,

Line 3869: ben_distribute_rates.periodize_with_rule

3865: if (nvl(l_vr_mn_elcn_val,l_abr.mn_elcn_val)) is not null then
3866: --GEVITY
3867: IF l_abr.rate_periodization_rl IS NOT NULL THEN
3868: --
3869: ben_distribute_rates.periodize_with_rule
3870: (p_formula_id => l_abr.rate_periodization_rl
3871: ,p_effective_date => nvl(p_lf_evt_ocrd_dt,l_effective_date)
3872: ,p_assignment_id => l_assignment_id
3873: ,p_convert_from_val => nvl(l_vr_mn_elcn_val,l_abr.mn_elcn_val)

Line 3886: l_cmcd_ann_mn_val := ben_distribute_rates.period_to_annual

3882: );
3883: --
3884: ELSE
3885: --
3886: l_cmcd_ann_mn_val := ben_distribute_rates.period_to_annual
3887: (p_amount => nvl(l_vr_mn_elcn_val,l_abr.mn_elcn_val),
3888: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
3889: p_acty_ref_perd_cd => l_acty_ref_perd_cd,
3890: p_business_group_id => l_epe.business_group_id,

Line 3902: l_cmcd_mn_val := ben_distribute_rates.annual_to_period

3898: else
3899: l_element_type_id := null;
3900: end if;
3901: --
3902: l_cmcd_mn_val := ben_distribute_rates.annual_to_period
3903: (p_amount =>l_cmcd_ann_mn_val ,
3904: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
3905: p_acty_ref_perd_cd => l_enrt_info_rt_freq_cd,
3906: p_business_group_id => l_epe.business_group_id,

Line 3920: ben_distribute_rates.periodize_with_rule

3916: if (nvl(l_vr_mx_elcn_val,l_abr.mx_elcn_val)) is not null then
3917: --GEVITY
3918: IF l_abr.rate_periodization_rl IS NOT NULL THEN
3919: --
3920: ben_distribute_rates.periodize_with_rule
3921: (p_formula_id => l_abr.rate_periodization_rl
3922: ,p_effective_date => nvl(p_lf_evt_ocrd_dt,l_effective_date)
3923: ,p_assignment_id => l_assignment_id
3924: ,p_convert_from_val => nvl(l_vr_mx_elcn_val,l_abr.mx_elcn_val)

Line 3938: l_cmcd_ann_mx_val := ben_distribute_rates.period_to_annual

3934: --
3935: ELSE
3936: --
3937: --
3938: l_cmcd_ann_mx_val := ben_distribute_rates.period_to_annual
3939: (p_amount => nvl(l_vr_mx_elcn_val,l_abr.mx_elcn_val),
3940: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
3941: p_acty_ref_perd_cd => l_acty_ref_perd_cd,
3942: p_business_group_id => l_epe.business_group_id,

Line 3955: l_cmcd_mx_val := ben_distribute_rates.annual_to_period

3951: else
3952: l_element_type_id := null;
3953: end if;
3954: --
3955: l_cmcd_mx_val := ben_distribute_rates.annual_to_period
3956: (p_amount =>l_cmcd_ann_mx_val,
3957: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
3958: p_acty_ref_perd_cd => l_enrt_info_rt_freq_cd,
3959: p_business_group_id => l_epe.business_group_id,

Line 3974: ben_distribute_rates.periodize_with_rule

3970: if l_abr.dflt_val is not null then
3971: --GEVITY
3972: IF l_abr.rate_periodization_rl IS NOT NULL THEN
3973: --
3974: ben_distribute_rates.periodize_with_rule
3975: (p_formula_id => l_abr.rate_periodization_rl
3976: ,p_effective_date => nvl(p_lf_evt_ocrd_dt,l_effective_date)
3977: ,p_assignment_id => l_assignment_id
3978: ,p_convert_from_val => l_abr.dflt_val

Line 3992: l_cmcd_ann_dflt_val := ben_distribute_rates.period_to_annual

3988: --
3989: ELSE
3990: --
3991: --
3992: l_cmcd_ann_dflt_val := ben_distribute_rates.period_to_annual
3993: (p_amount => l_abr.dflt_val,
3994: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
3995: p_acty_ref_perd_cd => l_acty_ref_perd_cd,
3996: p_business_group_id => l_epe.business_group_id,

Line 4009: l_cmcd_dflt_val := ben_distribute_rates.annual_to_period

4005: else
4006: l_element_type_id := null;
4007: end if;
4008: --
4009: l_cmcd_dflt_val := ben_distribute_rates.annual_to_period
4010: (p_amount =>l_cmcd_ann_dflt_val,
4011: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
4012: p_acty_ref_perd_cd => l_enrt_info_rt_freq_cd,
4013: p_business_group_id => l_epe.business_group_id,

Line 4479: ben_distribute_rates.periodize_with_rule

4475: --
4476: --GEVITY
4477: IF l_rate_periodization_rl IS NOT NULL THEN
4478: --
4479: ben_distribute_rates.periodize_with_rule
4480: (p_formula_id => l_rate_periodization_rl
4481: ,p_effective_date => l_effective_date
4482: ,p_assignment_id => l_assignment_id
4483: ,p_convert_from_val => p_bnft_amt

Line 4500: p_cmcd_val := ben_distribute_rates.annual_to_period

4496: open c_rt_strt_dt(l_enrt_rt.enrt_rt_id);
4497: fetch c_rt_strt_dt into l_rt_strt_dt;
4498: close c_rt_strt_dt;
4499: --
4500: p_cmcd_val := ben_distribute_rates.annual_to_period
4501: (p_amount => p_bnft_amt,
4502: p_enrt_rt_id => l_enrt_rt.enrt_rt_id,
4503: p_acty_ref_perd_cd => l_enrt_rt.cmcd_acty_ref_perd_cd,
4504: p_business_group_id => p_business_group_id,