APPS.BEN_DETERMINE_RATE_CHG dependencies on BEN_MANAGE_LIFE_EVENTS

Line 960: if ben_manage_life_events.fonm = 'Y' then

956: close c_ecr;
957: --
958: end if;
959: --
960: if ben_manage_life_events.fonm = 'Y' then
961: ben_manage_life_events.g_fonm_cvg_strt_dt :=
962: l_epe.fonm_cvg_strt_dt;
963: end if;
964:

Line 961: ben_manage_life_events.g_fonm_cvg_strt_dt :=

957: --
958: end if;
959: --
960: if ben_manage_life_events.fonm = 'Y' then
961: ben_manage_life_events.g_fonm_cvg_strt_dt :=
962: l_epe.fonm_cvg_strt_dt;
963: end if;
964:
965: hr_utility.set_location('Old Amount '||l_pen.bnft_amt,10);

Line 1213: if ben_manage_life_events.fonm = 'Y' then

1209: end if; --l_rt_strt_dt
1210: --
1211: end if; -- rv.rt_ovridn_flag = 'Y'
1212:
1213: if ben_manage_life_events.fonm = 'Y' then
1214: ben_manage_life_events.g_fonm_rt_strt_dt := l_rt_strt_dt;
1215: end if;
1216: --
1217: --Bug 3192923 If the rate was overriden in the previous enrollment

Line 1214: ben_manage_life_events.g_fonm_rt_strt_dt := l_rt_strt_dt;

1210: --
1211: end if; -- rv.rt_ovridn_flag = 'Y'
1212:
1213: if ben_manage_life_events.fonm = 'Y' then
1214: ben_manage_life_events.g_fonm_rt_strt_dt := l_rt_strt_dt;
1215: end if;
1216: --
1217: --Bug 3192923 If the rate was overriden in the previous enrollment
1218: --and the rate start date is not after the override thru date we

Line 1633: if ben_manage_life_events.fonm = 'Y' then

1629: ,p_lf_evt_ocrd_dt => nvl(l_pil.lf_evt_ocrd_dt,p_effective_date)
1630: );
1631: end if;
1632:
1633: if ben_manage_life_events.fonm = 'Y' then
1634: l_ppe_dt_to_use := l_enrt_cvg_strt_dt;
1635: ben_manage_life_events.g_fonm_rt_strt_dt := l_rt_strt_dt;
1636: ben_manage_life_events.g_fonm_cvg_strt_dt := l_enrt_cvg_strt_dt;
1637:

Line 1635: ben_manage_life_events.g_fonm_rt_strt_dt := l_rt_strt_dt;

1631: end if;
1632:
1633: if ben_manage_life_events.fonm = 'Y' then
1634: l_ppe_dt_to_use := l_enrt_cvg_strt_dt;
1635: ben_manage_life_events.g_fonm_rt_strt_dt := l_rt_strt_dt;
1636: ben_manage_life_events.g_fonm_cvg_strt_dt := l_enrt_cvg_strt_dt;
1637:
1638: else
1639: l_ppe_dt_to_use := greatest(l_pen.enrt_cvg_strt_dt,l_rt_strt_dt);

Line 1636: ben_manage_life_events.g_fonm_cvg_strt_dt := l_enrt_cvg_strt_dt;

1632:
1633: if ben_manage_life_events.fonm = 'Y' then
1634: l_ppe_dt_to_use := l_enrt_cvg_strt_dt;
1635: ben_manage_life_events.g_fonm_rt_strt_dt := l_rt_strt_dt;
1636: ben_manage_life_events.g_fonm_cvg_strt_dt := l_enrt_cvg_strt_dt;
1637:
1638: else
1639: l_ppe_dt_to_use := greatest(l_pen.enrt_cvg_strt_dt,l_rt_strt_dt);
1640: end if;

Line 1780: if ben_manage_life_events.fonm = 'Y' then

1776: close c_pen;
1777: --
1778: if l_pen_found then
1779: --
1780: if ben_manage_life_events.fonm = 'Y' then
1781: ben_manage_life_events.g_fonm_cvg_strt_dt :=
1782: l_epe.fonm_cvg_strt_dt;
1783: end if;
1784:

Line 1781: ben_manage_life_events.g_fonm_cvg_strt_dt :=

1777: --
1778: if l_pen_found then
1779: --
1780: if ben_manage_life_events.fonm = 'Y' then
1781: ben_manage_life_events.g_fonm_cvg_strt_dt :=
1782: l_epe.fonm_cvg_strt_dt;
1783: end if;
1784:
1785: ben_determine_coverage.main

Line 1871: if ben_manage_life_events.fonm = 'Y' then

1867:
1868: for l_ecr in c_ecr(l_epe.elig_per_elctbl_chc_id,
1869: l_enb.enrt_bnft_id) loop
1870:
1871: if ben_manage_life_events.fonm = 'Y' then
1872: if l_ecr.rt_strt_dt_cd is null then
1873: l_rt_strt_dt := l_ecr.rt_strt_dt;
1874: end if;
1875: --

Line 1908: ben_manage_life_events.g_fonm_rt_strt_dt := l_rt_strt_dt;

1904: ,p_lf_evt_ocrd_dt => nvl(l_pil.lf_evt_ocrd_dt,p_effective_date)
1905: );
1906: end if;
1907:
1908: ben_manage_life_events.g_fonm_rt_strt_dt := l_rt_strt_dt;
1909:
1910: end if;
1911:
1912: l_flex_call := true;

Line 1992: if ben_manage_life_events.fonm = 'Y' then

1988: if l_pen_found then
1989: --
1990: hr_utility.set_location (l_package,40);
1991: --
1992: if ben_manage_life_events.fonm = 'Y' then
1993: ben_manage_life_events.g_fonm_cvg_strt_dt :=
1994: l_epe.fonm_cvg_strt_dt;
1995: end if;
1996:

Line 1993: ben_manage_life_events.g_fonm_cvg_strt_dt :=

1989: --
1990: hr_utility.set_location (l_package,40);
1991: --
1992: if ben_manage_life_events.fonm = 'Y' then
1993: ben_manage_life_events.g_fonm_cvg_strt_dt :=
1994: l_epe.fonm_cvg_strt_dt;
1995: end if;
1996:
1997: open c_enb;

Line 2011: if ben_manage_life_events.fonm = 'Y' then

2007: end if; --
2008: close c_enb;
2009: for l_ecr in c_ecr2(l_epe.elig_per_elctbl_chc_id,
2010: l_enb.enrt_bnft_id) loop
2011: if ben_manage_life_events.fonm = 'Y' then
2012: if l_ecr.rt_strt_dt_cd is null then
2013: l_rt_strt_dt := l_ecr.rt_strt_dt;
2014: end if;
2015: --

Line 2048: ben_manage_life_events.g_fonm_rt_strt_dt := l_rt_strt_dt;

2044: ,p_lf_evt_ocrd_dt => nvl(l_pil.lf_evt_ocrd_dt,p_effective_date)
2045: );
2046: end if;
2047:
2048: ben_manage_life_events.g_fonm_rt_strt_dt := l_rt_strt_dt;
2049:
2050: end if;
2051:
2052: l_flex_call := true;