DBA Data[Home] [Help]

APPS.BEN_DERIVE_PART_AND_RATE_FACTS dependencies on BEN_DERIVE_PART_AND_RATE_PREM

Line 4329: ben_derive_part_and_rate_prem.get_los_rate(

4325: --
4326: END IF ; -- l_rate_cvg_rec.exist
4327:
4328: --
4329: ben_derive_part_and_rate_prem.get_los_rate(
4330: p_pl_id => p_pl_id
4331: ,p_oipl_id => p_oipl_id
4332: ,p_business_group_id => p_business_group_id
4333: ,p_effective_date => NVL(g_fonm_cvg_strt_dt,l_effective_date)

Line 4415: ben_derive_part_and_rate_prem.get_los_rate(p_pl_id=> p_pl_id

4411: ,p_fonm_cvg_strt_dt => g_fonm_cvg_strt_dt);
4412: --
4413: IF l_rate_prem_result is not null THEN
4414: --
4415: ben_derive_part_and_rate_prem.get_los_rate(p_pl_id=> p_pl_id
4416: ,p_oipl_id => p_oipl_id
4417: ,p_business_group_id => p_business_group_id
4418: ,p_new_val => l_rate_prem_result
4419: ,p_old_val => p_comp_rec.rt_los_val

Line 4968: ben_derive_part_and_rate_prem.get_age_rate(

4964: --
4965: -- Try and find a premium
4966: --
4967: --hr_utility.set_location('Getting Age for Prem',10);
4968: ben_derive_part_and_rate_prem.get_age_rate(
4969: p_pl_id => p_pl_id
4970: ,p_oipl_id => p_oipl_id
4971: ,p_business_group_id => p_business_group_id
4972: ,p_effective_date => nvl(g_fonm_cvg_strt_dt,NVL(p_lf_evt_ocrd_dt

Line 5008: ben_derive_part_and_rate_prem.get_age_rate(

5004: --
5005: IF l_rate_prem_result is not null THEN
5006: --
5007: --hr_utility.set_location(' in l_prem ' ,133);
5008: ben_derive_part_and_rate_prem.get_age_rate(
5009: p_pl_id => p_pl_id
5010: ,p_oipl_id => p_oipl_id
5011: ,p_business_group_id => p_business_group_id
5012: ,p_new_val => l_rate_prem_result

Line 6491: hr_utility.set_location(' Now call ben_derive_part_and_rate_prem ' , 80);

6487: IF p_oipl_id IS NOT NULL
6488: OR p_pl_id IS NOT NULL THEN
6489: --
6490: if g_debug then
6491: hr_utility.set_location(' Now call ben_derive_part_and_rate_prem ' , 80);
6492: end if;
6493: --
6494: ben_derive_part_and_rate_prem.get_comp_rate(
6495: p_pl_id => p_pl_id

Line 6494: ben_derive_part_and_rate_prem.get_comp_rate(

6490: if g_debug then
6491: hr_utility.set_location(' Now call ben_derive_part_and_rate_prem ' , 80);
6492: end if;
6493: --
6494: ben_derive_part_and_rate_prem.get_comp_rate(
6495: p_pl_id => p_pl_id
6496: ,p_oipl_id => p_oipl_id
6497: ,p_business_group_id => p_business_group_id
6498: ,p_effective_date => nvl(g_fonm_cvg_strt_dt,NVL(p_lf_evt_ocrd_dt

Line 6630: ben_derive_part_and_rate_prem.get_comp_rate(

6626: end if;
6627: --
6628: IF l_rate_prem_result is not null THEN
6629: --
6630: ben_derive_part_and_rate_prem.get_comp_rate(
6631: p_pl_id => p_pl_id
6632: ,p_oipl_id => p_oipl_id
6633: ,p_old_val => p_comp_rec.rt_comp_ref_amt
6634: ,p_new_val => l_rate_prem_result

Line 7291: ben_derive_part_and_rate_prem.get_comb_rate(

7287: OR p_pl_id IS NOT NULL THEN
7288: --
7289: -- Try and find a premium
7290: --
7291: ben_derive_part_and_rate_prem.get_comb_rate(
7292: p_pl_id => p_pl_id
7293: ,p_oipl_id => p_oipl_id
7294: ,p_business_group_id => p_business_group_id
7295: ,p_effective_date => NVL(g_fonm_cvg_strt_dt,NVL(p_lf_evt_ocrd_dt

Line 7353: ben_derive_part_and_rate_prem.get_comb_rate(

7349: --
7350: -- p_comp_rec.rt_cmbn_age_n_los_val := l_rate_prem_result;
7351: --
7352: --
7353: ben_derive_part_and_rate_prem.get_comb_rate(
7354: p_pl_id => p_pl_id
7355: ,p_oipl_id => p_oipl_id
7356: ,p_new_val => l_rate_prem_result
7357: ,p_old_val => p_comp_rec.rt_cmbn_age_n_los_val

Line 8039: ben_derive_part_and_rate_prem.get_pct_rate(

8035: OR p_pl_id IS NOT NULL THEN
8036: --
8037: -- Try and find a premium
8038: --
8039: ben_derive_part_and_rate_prem.get_pct_rate(
8040: p_pl_id => p_pl_id
8041: ,p_oipl_id => p_oipl_id
8042: ,p_business_group_id => p_business_group_id
8043: ,p_effective_date => nvl(g_fonm_cvg_strt_dt,NVL(p_lf_evt_ocrd_dt

Line 8102: ben_derive_part_and_rate_prem.get_pct_rate(

8098: END IF; -- l_rate_prem_rec.rndg_cd
8099: --
8100: IF l_rate_prem_result is not null THEN
8101: --
8102: ben_derive_part_and_rate_prem.get_pct_rate(
8103: p_pl_id => p_pl_id
8104: ,p_oipl_id => p_oipl_id
8105: ,p_new_val => l_rate_prem_result
8106: ,p_old_val => p_comp_rec.rt_pct_fl_tm_val

Line 9174: hr_utility.set_location(' Now call ben_derive_part_and_rate_prem ' , 80);

9170: --
9171: END IF ; -- oipl_id
9172: --
9173: if g_debug then
9174: hr_utility.set_location(' Now call ben_derive_part_and_rate_prem ' , 80);
9175: end if;
9176: IF p_oipl_id IS NOT NULL
9177: OR p_pl_id IS NOT NULL THEN
9178: --

Line 9181: ben_derive_part_and_rate_prem.get_hours_rate(p_pl_id=> p_pl_id

9177: OR p_pl_id IS NOT NULL THEN
9178: --
9179: -- Try and find a premium
9180: --
9181: ben_derive_part_and_rate_prem.get_hours_rate(p_pl_id=> p_pl_id
9182: ,p_oipl_id => p_oipl_id
9183: ,p_business_group_id => p_business_group_id
9184: ,p_effective_date => nvl(g_fonm_cvg_strt_dt,
9185: NVL(p_lf_evt_ocrd_dt ,p_effective_date))

Line 9285: ben_derive_part_and_rate_prem.get_hours_rate(

9281: --
9282: IF l_rate_prem_result is not null THEN
9283: --
9284: --
9285: ben_derive_part_and_rate_prem.get_hours_rate(
9286: p_pl_id => p_pl_id
9287: ,p_oipl_id => p_oipl_id
9288: ,p_old_val => p_comp_rec.rt_hrs_wkd_val
9289: ,p_new_val => l_rate_prem_result