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 664: ben_distribute_rates.periodize_with_rule

660: p_payroll_id => l_payroll_id,
661: p_assignment_id => l_assignment_id);
662: --
663: l_ann_dummy := p_ann_rt_val;
664: ben_distribute_rates.periodize_with_rule
665: (p_formula_id => p_rate_periodization_rl,
666: p_effective_date => p_effective_date,
667: p_assignment_id => l_assignment_id,
668: p_convert_from_val => l_ann_dummy,

Line 680: ben_distribute_rates.annual_to_period

676: p_val => l_compute_val);
677: --
678: ELSE
679: l_compute_val :=
680: ben_distribute_rates.annual_to_period
681: (p_amount => p_ann_rt_val,
682: p_enrt_rt_id => p_enrt_rt_id,
683: p_elig_per_elctbl_chc_id => NULL,
684: p_acty_ref_perd_cd => NULL,

Line 726: ben_distribute_rates.periodize_with_rule

722: p_assignment_id => l_assignment_id); */
723: --
724: l_dfnd_dummy := p_rt_val;
725: --
726: ben_distribute_rates.periodize_with_rule
727: (p_formula_id => p_rate_periodization_rl,
728: p_effective_date => p_effective_date,
729: p_assignment_id => l_assignment_id,
730: p_convert_from_val => l_dfnd_dummy,

Line 743: ben_distribute_rates.period_to_annual

739: --
740: ELSE
741: hr_utility.set_location('Calculate Annual value: '||l_payroll_id, 10);
742: l_compute_val :=
743: ben_distribute_rates.period_to_annual
744: (p_amount => p_rt_val,
745: p_enrt_rt_id => p_enrt_rt_id,
746: p_elig_per_elctbl_chc_id => NULL,
747: p_acty_ref_perd_cd => NULL,

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

1905: end if;
1906: --
1907: -- bug fix 3457483
1908: --
1909: -- Get the payroll id to be passed to ben_distribute_rates.
1910: --
1911: ben_element_entry.get_abr_assignment
1912: (p_person_id => p_person_id
1913: ,p_effective_date => l_effective_date

Line 2227: ben_distribute_rates.periodize_with_rule(

2223: );
2224: --
2225: l_ann_dummy := p_ann_rt_val;
2226: --
2227: ben_distribute_rates.periodize_with_rule(
2228: p_formula_id => l_enrt_rt.rate_periodization_rl
2229: ,p_effective_date => l_effective_date
2230: ,p_assignment_id => l_assignment_id
2231: ,p_convert_from_val => l_ann_dummy

Line 2243: l_compute_val := ben_distribute_rates.annual_to_period(

2239: ,p_val => l_compute_val
2240: );
2241: --
2242: ELSE
2243: l_compute_val := ben_distribute_rates.annual_to_period(
2244: p_amount => p_ann_rt_val
2245: ,p_enrt_rt_id => p_enrt_rt_id
2246: ,p_elig_per_elctbl_chc_id => null
2247: ,p_acty_ref_perd_cd => null

Line 2279: ben_distribute_rates.periodize_with_rule(

2275: );
2276: --
2277: l_dfnd_dummy := p_rt_val;
2278: --
2279: ben_distribute_rates.periodize_with_rule(
2280: p_formula_id => l_enrt_rt.rate_periodization_rl
2281: ,p_effective_date => l_effective_date
2282: ,p_assignment_id => l_assignment_id
2283: ,p_convert_from_val => l_dfnd_dummy

Line 2295: l_compute_val := ben_distribute_rates.period_to_annual(

2291: ,p_val => l_cmcd_dummy
2292: );
2293: --
2294: ELSE
2295: l_compute_val := ben_distribute_rates.period_to_annual(
2296: p_amount => p_rt_val
2297: ,p_enrt_rt_id => p_enrt_rt_id
2298: ,p_elig_per_elctbl_chc_id => null
2299: ,p_acty_ref_perd_cd => null

Line 2372: ben_distribute_rates.periodize_with_rule

2368: IF l_enrt_rt.rate_periodization_rl IS NOT NULL THEN
2369: --
2370: l_ann_dummy := l_ann_rt_val_param ; --p_ann_rt_val; 5259005
2371: --
2372: ben_distribute_rates.periodize_with_rule
2373: (p_formula_id => l_enrt_rt.rate_periodization_rl
2374: ,p_effective_date => l_effective_date
2375: ,p_assignment_id => l_assignment_id
2376: ,p_convert_from_val => l_ann_dummy

Line 2391: l_enrt_rt.cmcd_val := ben_distribute_rates.annual_to_period

2387: ELSE
2388: -- use ann_rt_val to drive other values
2389: --
2390: --
2391: l_enrt_rt.cmcd_val := ben_distribute_rates.annual_to_period
2392: (p_amount => l_ann_rt_val_param, -- p_ann_rt_val, 5259005
2393: p_elig_per_elctbl_chc_id => l_enrt_rt.elig_per_elctbl_chc_id,
2394: p_acty_ref_perd_cd => l_enrt_rt.cmcd_acty_ref_perd_cd,
2395: p_business_group_id => p_business_group_id,

Line 2410: l_rt_val := ben_distribute_rates.annual_to_period

2406: else
2407: --Bug 3253180
2408: --l_rt_val:= l_enrt_rt.cmcd_val;
2409: --
2410: l_rt_val := ben_distribute_rates.annual_to_period
2411: (p_amount => l_ann_rt_val_param, --p_ann_rt_val, 5259005
2412: p_enrt_rt_id => p_enrt_rt_id,
2413: p_acty_ref_perd_cd => p_acty_ref_perd_cd,
2414: p_business_group_id => p_business_group_id,

Line 2477: ben_distribute_rates.periodize_with_rule

2473: IF l_enrt_rt.rate_periodization_rl IS NOT NULL THEN
2474: --
2475: l_ann_dummy := l_ann_rt_val;
2476: --
2477: ben_distribute_rates.periodize_with_rule
2478: (p_formula_id => l_enrt_rt.rate_periodization_rl
2479: ,p_effective_date => l_effective_date
2480: ,p_assignment_id => l_assignment_id
2481: ,p_convert_from_val => l_ann_dummy

Line 2494: l_rt_val := ben_distribute_rates.annual_to_period(

2490: );
2491: --
2492: ELSE
2493: --
2494: l_rt_val := ben_distribute_rates.annual_to_period(
2495: p_amount => l_ann_rt_val
2496: ,p_enrt_rt_id =>p_enrt_rt_id
2497: ,p_elig_per_elctbl_chc_id => null
2498: ,p_acty_ref_perd_cd => null

Line 2521: l_enrt_rt.cmcd_val := ben_distribute_rates.annual_to_period

2517: else
2518: --
2519: --
2520: --
2521: l_enrt_rt.cmcd_val := ben_distribute_rates.annual_to_period
2522: (p_amount => l_ann_rt_val,
2523: --p_elig_per_elctbl_chc_id => l_enrt_rt.elig_per_elctbl_chc_id,
2524: p_enrt_rt_id => p_enrt_rt_id,
2525: p_acty_ref_perd_cd => l_enrt_rt.cmcd_acty_ref_perd_cd,

Line 2597: ben_distribute_rates.periodize_with_rule

2593: IF l_enrt_rt.rate_periodization_rl IS NOT NULL THEN
2594: --
2595: l_ann_dummy := l_ann_rt_val;
2596: --
2597: ben_distribute_rates.periodize_with_rule
2598: (p_formula_id => l_enrt_rt.rate_periodization_rl
2599: ,p_effective_date => l_effective_date
2600: ,p_assignment_id => l_assignment_id
2601: ,p_convert_from_val => l_ann_dummy

Line 2614: l_rt_val := ben_distribute_rates.annual_to_period

2610: );
2611: --
2612: ELSE
2613: --
2614: l_rt_val := ben_distribute_rates.annual_to_period
2615: (p_amount => l_ann_rt_val,
2616: p_enrt_rt_id => p_enrt_rt_id,
2617: p_acty_ref_perd_cd => p_acty_ref_perd_cd,
2618: p_business_group_id => p_business_group_id,

Line 2635: l_enrt_rt.cmcd_val := ben_distribute_rates.annual_to_period

2631: else
2632: --
2633: l_rt_val := round(l_rt_val,4);
2634: --
2635: l_enrt_rt.cmcd_val := ben_distribute_rates.annual_to_period
2636: (p_amount => l_ann_rt_val,
2637: --p_elig_per_elctbl_chc_id => l_enrt_rt.elig_per_elctbl_chc_id,
2638: p_enrt_rt_id => p_enrt_rt_id,
2639: p_acty_ref_perd_cd => l_enrt_rt.cmcd_acty_ref_perd_cd,

Line 3007: ben_distribute_rates.periodize_with_rule

3003: IF l_enrt_rt.rate_periodization_rl IS NOT NULL THEN
3004: --
3005: l_dfnd_dummy := l_rt_val;
3006: --
3007: ben_distribute_rates.periodize_with_rule
3008: (p_formula_id => l_enrt_rt.rate_periodization_rl
3009: ,p_effective_date => l_effective_date
3010: ,p_assignment_id => l_assignment_id
3011: ,p_convert_from_val => l_dfnd_dummy

Line 3024: l_ann_rt_val := ben_distribute_rates.period_to_annual

3020: );
3021: --
3022: ELSE
3023: --
3024: l_ann_rt_val := ben_distribute_rates.period_to_annual
3025: (p_amount => l_rt_val
3026: ,p_enrt_rt_id => p_enrt_rt_id
3027: ,p_elig_per_elctbl_chc_id => l_enrt_rt.elig_per_elctbl_chc_id
3028: ,p_acty_ref_perd_cd => p_acty_ref_perd_cd

Line 3038: l_calc_ann_val := ben_distribute_rates.period_to_annual

3034: );
3035: --
3036: -- always compute the cmcd rate based on the annual value
3037: --
3038: l_calc_ann_val := ben_distribute_rates.period_to_annual
3039: (p_amount => l_rt_val
3040: ,p_enrt_rt_id => p_enrt_rt_id
3041: ,p_elig_per_elctbl_chc_id => l_enrt_rt.elig_per_elctbl_chc_id
3042: ,p_acty_ref_perd_cd => p_acty_ref_perd_cd

Line 3049: l_enrt_rt.cmcd_val := ben_distribute_rates.annual_to_period

3045: ,p_complete_year_flag => 'Y'
3046: ,p_payroll_id => l_payroll_id
3047: );
3048: --
3049: l_enrt_rt.cmcd_val := ben_distribute_rates.annual_to_period
3050: (p_amount => l_calc_ann_val
3051: ,p_elig_per_elctbl_chc_id => l_enrt_rt.elig_per_elctbl_chc_id
3052: ,p_acty_ref_perd_cd => l_enrt_rt.cmcd_acty_ref_perd_cd
3053: ,p_business_group_id => p_business_group_id

Line 3148: ben_distribute_rates.periodize_with_rule

3144: IF l_enrt_rt.rate_periodization_rl IS NOT NULL THEN
3145: --
3146: l_ann_dummy := l_ann_rt_val;
3147: --
3148: ben_distribute_rates.periodize_with_rule
3149: (p_formula_id => l_enrt_rt.rate_periodization_rl
3150: ,p_effective_date => l_effective_date
3151: ,p_assignment_id => l_assignment_id
3152: ,p_convert_from_val => l_ann_dummy

Line 3165: l_rt_val := ben_distribute_rates.annual_to_period

3161: );
3162: --
3163: ELSE
3164: --
3165: l_rt_val := ben_distribute_rates.annual_to_period
3166: (p_amount => l_ann_rt_val,
3167: p_enrt_rt_id => p_enrt_rt_id,
3168: p_acty_ref_perd_cd => p_acty_ref_perd_cd,
3169: p_business_group_id => p_business_group_id,

Line 3196: l_calc_ann_val := ben_distribute_rates.period_to_annual

3192: end if;
3193: /**
3194: when annual value is passed there is no need to compute the annual value
3195: from defined value - bug#2398448 and bug#2392732
3196: l_calc_ann_val := ben_distribute_rates.period_to_annual
3197: (p_amount => l_rt_val,
3198: p_enrt_rt_id => p_enrt_rt_id,
3199: p_acty_ref_perd_cd => p_acty_ref_perd_cd,
3200: p_business_group_id => p_business_group_id,

Line 3216: ben_distribute_rates.compare_balances

3212: --Bug#3540351
3213: if l_rt_val < 0 then
3214: l_rt_val := 0;
3215: l_enrt_rt.cmcd_val := 0;
3216: ben_distribute_rates.compare_balances
3217: (p_person_id => p_person_id
3218: ,p_effective_date => l_effective_date
3219: ,p_elig_per_elctbl_chc_id => l_enrt_rt.elig_per_elctbl_chc_id
3220: ,p_acty_base_rt_id => l_enrt_rt.acty_base_rt_id

Line 3244: l_enrt_rt.cmcd_val := ben_distribute_rates.annual_to_period

3240: p_person_id => p_person_id);
3241: end if;
3242: else
3243: --
3244: l_enrt_rt.cmcd_val := ben_distribute_rates.annual_to_period
3245: (p_amount => l_calc_ann_val,
3246: -- p_elig_per_elctbl_chc_id => l_enrt_rt.elig_per_elctbl_chc_id,
3247: p_enrt_rt_id => p_enrt_rt_id,
3248: p_acty_ref_perd_cd => l_enrt_rt.cmcd_acty_ref_perd_cd,