APPS.BEN_DETERMINE_RATE_CHG dependencies on BEN_MANAGE_LIFE_EVENTS

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

1042: close c_ecr;
1043: --
1044: end if;
1045: --
1046: if ben_manage_life_events.fonm = 'Y' then
1047: ben_manage_life_events.g_fonm_cvg_strt_dt :=
1048: l_epe.fonm_cvg_strt_dt;
1049: end if;
1050:

Line 1047: ben_manage_life_events.g_fonm_cvg_strt_dt :=

1043: --
1044: end if;
1045: --
1046: if ben_manage_life_events.fonm = 'Y' then
1047: ben_manage_life_events.g_fonm_cvg_strt_dt :=
1048: l_epe.fonm_cvg_strt_dt;
1049: end if;
1050:
1051: hr_utility.set_location('Old Amount '||l_pen.bnft_amt,10);

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

1328: end if; --l_rt_strt_dt
1329: --
1330: end if; -- rv.rt_ovridn_flag = 'Y'
1331:
1332: if ben_manage_life_events.fonm = 'Y' then
1333: ben_manage_life_events.g_fonm_rt_strt_dt := l_rt_strt_dt;
1334: end if;
1335: --
1336: --Bug 3192923 If the rate was overriden in the previous enrollment

Line 1333: ben_manage_life_events.g_fonm_rt_strt_dt := l_rt_strt_dt;

1329: --
1330: end if; -- rv.rt_ovridn_flag = 'Y'
1331:
1332: if ben_manage_life_events.fonm = 'Y' then
1333: ben_manage_life_events.g_fonm_rt_strt_dt := l_rt_strt_dt;
1334: end if;
1335: --
1336: --Bug 3192923 If the rate was overriden in the previous enrollment
1337: --and the rate start date is not after the override thru date we

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

1812: ,p_lf_evt_ocrd_dt => nvl(l_pil.lf_evt_ocrd_dt,p_effective_date)
1813: );
1814: end if;
1815:
1816: if ben_manage_life_events.fonm = 'Y' then
1817: l_ppe_dt_to_use := l_enrt_cvg_strt_dt;
1818: ben_manage_life_events.g_fonm_rt_strt_dt := l_rt_strt_dt;
1819: ben_manage_life_events.g_fonm_cvg_strt_dt := l_enrt_cvg_strt_dt;
1820:

Line 1818: ben_manage_life_events.g_fonm_rt_strt_dt := l_rt_strt_dt;

1814: end if;
1815:
1816: if ben_manage_life_events.fonm = 'Y' then
1817: l_ppe_dt_to_use := l_enrt_cvg_strt_dt;
1818: ben_manage_life_events.g_fonm_rt_strt_dt := l_rt_strt_dt;
1819: ben_manage_life_events.g_fonm_cvg_strt_dt := l_enrt_cvg_strt_dt;
1820:
1821: else
1822: l_ppe_dt_to_use := greatest(l_pen.enrt_cvg_strt_dt,l_rt_strt_dt);

Line 1819: ben_manage_life_events.g_fonm_cvg_strt_dt := l_enrt_cvg_strt_dt;

1815:
1816: if ben_manage_life_events.fonm = 'Y' then
1817: l_ppe_dt_to_use := l_enrt_cvg_strt_dt;
1818: ben_manage_life_events.g_fonm_rt_strt_dt := l_rt_strt_dt;
1819: ben_manage_life_events.g_fonm_cvg_strt_dt := l_enrt_cvg_strt_dt;
1820:
1821: else
1822: l_ppe_dt_to_use := greatest(l_pen.enrt_cvg_strt_dt,l_rt_strt_dt);
1823: end if;

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

1959: close c_pen;
1960: --
1961: if l_pen_found then
1962: --
1963: if ben_manage_life_events.fonm = 'Y' then
1964: ben_manage_life_events.g_fonm_cvg_strt_dt :=
1965: l_epe.fonm_cvg_strt_dt;
1966: end if;
1967:

Line 1964: ben_manage_life_events.g_fonm_cvg_strt_dt :=

1960: --
1961: if l_pen_found then
1962: --
1963: if ben_manage_life_events.fonm = 'Y' then
1964: ben_manage_life_events.g_fonm_cvg_strt_dt :=
1965: l_epe.fonm_cvg_strt_dt;
1966: end if;
1967:
1968: ben_determine_coverage.main

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

2050:
2051: for l_ecr in c_ecr(l_epe.elig_per_elctbl_chc_id,
2052: l_enb.enrt_bnft_id) loop
2053:
2054: if ben_manage_life_events.fonm = 'Y' then
2055: if l_ecr.rt_strt_dt_cd is null then
2056: l_rt_strt_dt := l_ecr.rt_strt_dt;
2057: end if;
2058: --

Line 2091: ben_manage_life_events.g_fonm_rt_strt_dt := l_rt_strt_dt;

2087: ,p_lf_evt_ocrd_dt => nvl(l_pil.lf_evt_ocrd_dt,p_effective_date)
2088: );
2089: end if;
2090:
2091: ben_manage_life_events.g_fonm_rt_strt_dt := l_rt_strt_dt;
2092:
2093: end if;
2094:
2095: l_flex_call := true;

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

2171: if l_pen_found then
2172: --
2173: hr_utility.set_location (l_package,40);
2174: --
2175: if ben_manage_life_events.fonm = 'Y' then
2176: ben_manage_life_events.g_fonm_cvg_strt_dt :=
2177: l_epe.fonm_cvg_strt_dt;
2178: end if;
2179:

Line 2176: ben_manage_life_events.g_fonm_cvg_strt_dt :=

2172: --
2173: hr_utility.set_location (l_package,40);
2174: --
2175: if ben_manage_life_events.fonm = 'Y' then
2176: ben_manage_life_events.g_fonm_cvg_strt_dt :=
2177: l_epe.fonm_cvg_strt_dt;
2178: end if;
2179:
2180: open c_enb;

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

2190: end if; --
2191: close c_enb;
2192: for l_ecr in c_ecr2(l_epe.elig_per_elctbl_chc_id,
2193: l_enb.enrt_bnft_id) loop
2194: if ben_manage_life_events.fonm = 'Y' then
2195: if l_ecr.rt_strt_dt_cd is null then
2196: l_rt_strt_dt := l_ecr.rt_strt_dt;
2197: end if;
2198: --

Line 2231: ben_manage_life_events.g_fonm_rt_strt_dt := l_rt_strt_dt;

2227: ,p_lf_evt_ocrd_dt => nvl(l_pil.lf_evt_ocrd_dt,p_effective_date)
2228: );
2229: end if;
2230:
2231: ben_manage_life_events.g_fonm_rt_strt_dt := l_rt_strt_dt;
2232:
2233: end if;
2234:
2235: l_flex_call := true;