DBA Data[Home] [Help]

APPS.BEN_ELECTION_INFORMATION dependencies on BEN_DISTRIBUTE_RATES

Line 126: 20-Jan-2000 maagrawa 115.56 Pass payroll_id to ben_distribute_rates

122: 14-Dec-1999 jcarpent 115.53 - Removed 'STRTD' restriction on pil.
123: 16-Dec-1999 jcarpent 115.54 - Recompute cvg date if bnft amt chg
124: 03-Jan-2000 lmcdonal 115.55 Bug 1121022. Do not re-calc rt-strt-dt
125: if a prtt-rt-val row exists.
126: 20-Jan-2000 maagrawa 115.56 Pass payroll_id to ben_distribute_rates
127: 21-Jan-2000 lmcdonal 115.57 If the rate is mult-of-cvg and cvg
128: can be entered at enrt, re-calc rate.
129: Bug 1118016.
130: 25-Jan-2000 maagrawa 115.58 Pass per_in_ler_id to

Line 596: ben_distribute_rates.periodize_with_rule

592: p_payroll_id => l_payroll_id,
593: p_assignment_id => l_assignment_id);
594: --
595: l_ann_dummy := p_ann_rt_val;
596: ben_distribute_rates.periodize_with_rule
597: (p_formula_id => p_rate_periodization_rl,
598: p_effective_date => p_effective_date,
599: p_assignment_id => l_assignment_id,
600: p_convert_from_val => l_ann_dummy,

Line 612: ben_distribute_rates.annual_to_period

608: p_val => l_compute_val);
609: --
610: ELSE
611: l_compute_val :=
612: ben_distribute_rates.annual_to_period
613: (p_amount => p_ann_rt_val,
614: p_enrt_rt_id => p_enrt_rt_id,
615: p_elig_per_elctbl_chc_id => NULL,
616: p_acty_ref_perd_cd => NULL,

Line 645: ben_distribute_rates.periodize_with_rule

641: p_assignment_id => l_assignment_id);
642: --
643: l_dfnd_dummy := p_rt_val;
644: --
645: ben_distribute_rates.periodize_with_rule
646: (p_formula_id => p_rate_periodization_rl,
647: p_effective_date => p_effective_date,
648: p_assignment_id => l_assignment_id,
649: p_convert_from_val => l_dfnd_dummy,

Line 661: ben_distribute_rates.period_to_annual

657: p_val => l_cmcd_dummy);
658: --
659: ELSE
660: l_compute_val :=
661: ben_distribute_rates.period_to_annual
662: (p_amount => p_rt_val,
663: p_enrt_rt_id => p_enrt_rt_id,
664: p_elig_per_elctbl_chc_id => NULL,
665: p_acty_ref_perd_cd => NULL,

Line 1552: -- Get the payroll id to be passed to ben_distribute_rates.

1548: end if;
1549: --
1550: -- bug fix 3457483
1551: --
1552: -- Get the payroll id to be passed to ben_distribute_rates.
1553: --
1554: ben_element_entry.get_abr_assignment
1555: (p_person_id => p_person_id
1556: ,p_effective_date => l_effective_date

Line 1869: ben_distribute_rates.periodize_with_rule(

1865: );
1866: --
1867: l_ann_dummy := p_ann_rt_val;
1868: --
1869: ben_distribute_rates.periodize_with_rule(
1870: p_formula_id => l_enrt_rt.rate_periodization_rl
1871: ,p_effective_date => l_effective_date
1872: ,p_assignment_id => l_assignment_id
1873: ,p_convert_from_val => l_ann_dummy

Line 1885: l_compute_val := ben_distribute_rates.annual_to_period(

1881: ,p_val => l_compute_val
1882: );
1883: --
1884: ELSE
1885: l_compute_val := ben_distribute_rates.annual_to_period(
1886: p_amount => p_ann_rt_val
1887: ,p_enrt_rt_id => p_enrt_rt_id
1888: ,p_elig_per_elctbl_chc_id => null
1889: ,p_acty_ref_perd_cd => null

Line 1921: ben_distribute_rates.periodize_with_rule(

1917: );
1918: --
1919: l_dfnd_dummy := p_rt_val;
1920: --
1921: ben_distribute_rates.periodize_with_rule(
1922: p_formula_id => l_enrt_rt.rate_periodization_rl
1923: ,p_effective_date => l_effective_date
1924: ,p_assignment_id => l_assignment_id
1925: ,p_convert_from_val => l_dfnd_dummy

Line 1937: l_compute_val := ben_distribute_rates.period_to_annual(

1933: ,p_val => l_cmcd_dummy
1934: );
1935: --
1936: ELSE
1937: l_compute_val := ben_distribute_rates.period_to_annual(
1938: p_amount => p_rt_val
1939: ,p_enrt_rt_id => p_enrt_rt_id
1940: ,p_elig_per_elctbl_chc_id => null
1941: ,p_acty_ref_perd_cd => null

Line 2014: ben_distribute_rates.periodize_with_rule

2010: IF l_enrt_rt.rate_periodization_rl IS NOT NULL THEN
2011: --
2012: l_ann_dummy := l_ann_rt_val_param ; --p_ann_rt_val; 5259005
2013: --
2014: ben_distribute_rates.periodize_with_rule
2015: (p_formula_id => l_enrt_rt.rate_periodization_rl
2016: ,p_effective_date => l_effective_date
2017: ,p_assignment_id => l_assignment_id
2018: ,p_convert_from_val => l_ann_dummy

Line 2033: l_enrt_rt.cmcd_val := ben_distribute_rates.annual_to_period

2029: ELSE
2030: -- use ann_rt_val to drive other values
2031: --
2032: --
2033: l_enrt_rt.cmcd_val := ben_distribute_rates.annual_to_period
2034: (p_amount => l_ann_rt_val_param, -- p_ann_rt_val, 5259005
2035: p_elig_per_elctbl_chc_id => l_enrt_rt.elig_per_elctbl_chc_id,
2036: p_acty_ref_perd_cd => l_enrt_rt.cmcd_acty_ref_perd_cd,
2037: p_business_group_id => p_business_group_id,

Line 2052: l_rt_val := ben_distribute_rates.annual_to_period

2048: else
2049: --Bug 3253180
2050: --l_rt_val:= l_enrt_rt.cmcd_val;
2051: --
2052: l_rt_val := ben_distribute_rates.annual_to_period
2053: (p_amount => l_ann_rt_val_param, --p_ann_rt_val, 5259005
2054: p_enrt_rt_id => p_enrt_rt_id,
2055: p_acty_ref_perd_cd => p_acty_ref_perd_cd,
2056: p_business_group_id => p_business_group_id,

Line 2119: ben_distribute_rates.periodize_with_rule

2115: IF l_enrt_rt.rate_periodization_rl IS NOT NULL THEN
2116: --
2117: l_ann_dummy := l_ann_rt_val;
2118: --
2119: ben_distribute_rates.periodize_with_rule
2120: (p_formula_id => l_enrt_rt.rate_periodization_rl
2121: ,p_effective_date => l_effective_date
2122: ,p_assignment_id => l_assignment_id
2123: ,p_convert_from_val => l_ann_dummy

Line 2136: l_rt_val := ben_distribute_rates.annual_to_period(

2132: );
2133: --
2134: ELSE
2135: --
2136: l_rt_val := ben_distribute_rates.annual_to_period(
2137: p_amount => l_ann_rt_val
2138: ,p_enrt_rt_id =>p_enrt_rt_id
2139: ,p_elig_per_elctbl_chc_id => null
2140: ,p_acty_ref_perd_cd => null

Line 2163: l_enrt_rt.cmcd_val := ben_distribute_rates.annual_to_period

2159: else
2160: --
2161: --
2162: --
2163: l_enrt_rt.cmcd_val := ben_distribute_rates.annual_to_period
2164: (p_amount => l_ann_rt_val,
2165: --p_elig_per_elctbl_chc_id => l_enrt_rt.elig_per_elctbl_chc_id,
2166: p_enrt_rt_id => p_enrt_rt_id,
2167: p_acty_ref_perd_cd => l_enrt_rt.cmcd_acty_ref_perd_cd,

Line 2226: ben_distribute_rates.periodize_with_rule

2222: IF l_enrt_rt.rate_periodization_rl IS NOT NULL THEN
2223: --
2224: l_ann_dummy := l_ann_rt_val;
2225: --
2226: ben_distribute_rates.periodize_with_rule
2227: (p_formula_id => l_enrt_rt.rate_periodization_rl
2228: ,p_effective_date => l_effective_date
2229: ,p_assignment_id => l_assignment_id
2230: ,p_convert_from_val => l_ann_dummy

Line 2243: l_rt_val := ben_distribute_rates.annual_to_period

2239: );
2240: --
2241: ELSE
2242: --
2243: l_rt_val := ben_distribute_rates.annual_to_period
2244: (p_amount => l_ann_rt_val,
2245: p_enrt_rt_id => p_enrt_rt_id,
2246: p_acty_ref_perd_cd => p_acty_ref_perd_cd,
2247: p_business_group_id => p_business_group_id,

Line 2264: l_enrt_rt.cmcd_val := ben_distribute_rates.annual_to_period

2260: else
2261: --
2262: l_rt_val := round(l_rt_val,4);
2263: --
2264: l_enrt_rt.cmcd_val := ben_distribute_rates.annual_to_period
2265: (p_amount => l_ann_rt_val,
2266: --p_elig_per_elctbl_chc_id => l_enrt_rt.elig_per_elctbl_chc_id,
2267: p_enrt_rt_id => p_enrt_rt_id,
2268: p_acty_ref_perd_cd => l_enrt_rt.cmcd_acty_ref_perd_cd,

Line 2635: ben_distribute_rates.periodize_with_rule

2631: IF l_enrt_rt.rate_periodization_rl IS NOT NULL THEN
2632: --
2633: l_dfnd_dummy := l_rt_val;
2634: --
2635: ben_distribute_rates.periodize_with_rule
2636: (p_formula_id => l_enrt_rt.rate_periodization_rl
2637: ,p_effective_date => l_effective_date
2638: ,p_assignment_id => l_assignment_id
2639: ,p_convert_from_val => l_dfnd_dummy

Line 2652: l_ann_rt_val := ben_distribute_rates.period_to_annual

2648: );
2649: --
2650: ELSE
2651: --
2652: l_ann_rt_val := ben_distribute_rates.period_to_annual
2653: (p_amount => l_rt_val
2654: ,p_enrt_rt_id => p_enrt_rt_id
2655: ,p_elig_per_elctbl_chc_id => l_enrt_rt.elig_per_elctbl_chc_id
2656: ,p_acty_ref_perd_cd => p_acty_ref_perd_cd

Line 2666: l_calc_ann_val := ben_distribute_rates.period_to_annual

2662: );
2663: --
2664: -- always compute the cmcd rate based on the annual value
2665: --
2666: l_calc_ann_val := ben_distribute_rates.period_to_annual
2667: (p_amount => l_rt_val
2668: ,p_enrt_rt_id => p_enrt_rt_id
2669: ,p_elig_per_elctbl_chc_id => l_enrt_rt.elig_per_elctbl_chc_id
2670: ,p_acty_ref_perd_cd => p_acty_ref_perd_cd

Line 2677: l_enrt_rt.cmcd_val := ben_distribute_rates.annual_to_period

2673: ,p_complete_year_flag => 'Y'
2674: ,p_payroll_id => l_payroll_id
2675: );
2676: --
2677: l_enrt_rt.cmcd_val := ben_distribute_rates.annual_to_period
2678: (p_amount => l_calc_ann_val
2679: ,p_elig_per_elctbl_chc_id => l_enrt_rt.elig_per_elctbl_chc_id
2680: ,p_acty_ref_perd_cd => l_enrt_rt.cmcd_acty_ref_perd_cd
2681: ,p_business_group_id => p_business_group_id

Line 2749: ben_distribute_rates.periodize_with_rule

2745: IF l_enrt_rt.rate_periodization_rl IS NOT NULL THEN
2746: --
2747: l_ann_dummy := l_ann_rt_val;
2748: --
2749: ben_distribute_rates.periodize_with_rule
2750: (p_formula_id => l_enrt_rt.rate_periodization_rl
2751: ,p_effective_date => l_effective_date
2752: ,p_assignment_id => l_assignment_id
2753: ,p_convert_from_val => l_ann_dummy

Line 2766: l_rt_val := ben_distribute_rates.annual_to_period

2762: );
2763: --
2764: ELSE
2765: --
2766: l_rt_val := ben_distribute_rates.annual_to_period
2767: (p_amount => l_ann_rt_val,
2768: p_enrt_rt_id => p_enrt_rt_id,
2769: p_acty_ref_perd_cd => p_acty_ref_perd_cd,
2770: p_business_group_id => p_business_group_id,

Line 2796: l_calc_ann_val := ben_distribute_rates.period_to_annual

2792: end if;
2793: /**
2794: when annual value is passed there is no need to compute the annual value
2795: from defined value - bug#2398448 and bug#2392732
2796: l_calc_ann_val := ben_distribute_rates.period_to_annual
2797: (p_amount => l_rt_val,
2798: p_enrt_rt_id => p_enrt_rt_id,
2799: p_acty_ref_perd_cd => p_acty_ref_perd_cd,
2800: p_business_group_id => p_business_group_id,

Line 2816: ben_distribute_rates.compare_balances

2812: --Bug#3540351
2813: if l_rt_val < 0 then
2814: l_rt_val := 0;
2815: l_enrt_rt.cmcd_val := 0;
2816: ben_distribute_rates.compare_balances
2817: (p_person_id => p_person_id
2818: ,p_effective_date => l_effective_date
2819: ,p_elig_per_elctbl_chc_id => l_enrt_rt.elig_per_elctbl_chc_id
2820: ,p_acty_base_rt_id => l_enrt_rt.acty_base_rt_id

Line 2844: l_enrt_rt.cmcd_val := ben_distribute_rates.annual_to_period

2840: p_person_id => p_person_id);
2841: end if;
2842: else
2843: --
2844: l_enrt_rt.cmcd_val := ben_distribute_rates.annual_to_period
2845: (p_amount => l_calc_ann_val,
2846: -- p_elig_per_elctbl_chc_id => l_enrt_rt.elig_per_elctbl_chc_id,
2847: p_enrt_rt_id => p_enrt_rt_id,
2848: p_acty_ref_perd_cd => l_enrt_rt.cmcd_acty_ref_perd_cd,