eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_ELECTION_INFORMATION dependencies on BEN_MANAGE_LIFE_EVENTS

Line 1084: and ( (ben_manage_life_events.fonm = 'Y' and

1080: ben_acty_base_rt_f abr
1081: where er.enrt_rt_id=p_enrt_rt_id
1082: and eb.enrt_bnft_id(+)=er.enrt_bnft_id
1083: and er.acty_base_rt_id=abr.acty_base_rt_id
1084: and ( (ben_manage_life_events.fonm = 'Y' and
1085: nvl(nvl(p_rt_strt_dt,er.rt_strt_dt),l_effective_date) between
1086: abr.effective_start_date and abr.effective_end_date) or
1087: (nvl(ben_manage_life_events.fonm,'N') = 'N'
1088: and l_effective_date between abr.effective_start_date

Line 1087: (nvl(ben_manage_life_events.fonm,'N') = 'N'

1083: and er.acty_base_rt_id=abr.acty_base_rt_id
1084: and ( (ben_manage_life_events.fonm = 'Y' and
1085: nvl(nvl(p_rt_strt_dt,er.rt_strt_dt),l_effective_date) between
1086: abr.effective_start_date and abr.effective_end_date) or
1087: (nvl(ben_manage_life_events.fonm,'N') = 'N'
1088: and l_effective_date between abr.effective_start_date
1089: and abr.effective_end_date) ) ;
1090: l_enrt_rt c_enrt_rt%rowtype;
1091:

Line 1365: AND ( ( ben_manage_life_events.fonm = 'Y'

1361: AND eb.enrt_bnft_id = er.enrt_bnft_id
1362: AND er.acty_base_rt_id = abr.acty_base_rt_id
1363: AND l_effective_date BETWEEN pen.effective_start_date
1364: AND pen.effective_end_date
1365: AND ( ( ben_manage_life_events.fonm = 'Y'
1366: AND NVL (er.rt_strt_dt, l_effective_date)
1367: BETWEEN abr.effective_start_date
1368: AND abr.effective_end_date
1369: )

Line 1370: OR ( NVL (ben_manage_life_events.fonm, 'N') = 'N'

1366: AND NVL (er.rt_strt_dt, l_effective_date)
1367: BETWEEN abr.effective_start_date
1368: AND abr.effective_end_date
1369: )
1370: OR ( NVL (ben_manage_life_events.fonm, 'N') = 'N'
1371: AND l_effective_date BETWEEN abr.effective_start_date
1372: AND abr.effective_end_date
1373: )
1374: );

Line 1488: if ben_manage_life_events.fonm is null then

1484: if l_global_pil_rec.typ_cd = 'SCHEDDU' then
1485: l_unrestricted := 'Y';
1486: end if;
1487:
1488: if ben_manage_life_events.fonm is null then
1489:
1490: open c_epe;
1491: fetch c_epe into l_fonm_cvg_strt_dt;
1492: close c_epe;

Line 1495: ben_manage_life_events.fonm := 'Y';

1491: fetch c_epe into l_fonm_cvg_strt_dt;
1492: close c_epe;
1493:
1494: if l_fonm_cvg_strt_dt is not null then
1495: ben_manage_life_events.fonm := 'Y';
1496: ben_manage_life_events.g_fonm_cvg_strt_dt := l_fonm_cvg_strt_dt;
1497: else
1498: ben_manage_life_events.fonm := 'N';
1499: ben_manage_life_events.g_fonm_cvg_strt_dt := null;

Line 1496: ben_manage_life_events.g_fonm_cvg_strt_dt := l_fonm_cvg_strt_dt;

1492: close c_epe;
1493:
1494: if l_fonm_cvg_strt_dt is not null then
1495: ben_manage_life_events.fonm := 'Y';
1496: ben_manage_life_events.g_fonm_cvg_strt_dt := l_fonm_cvg_strt_dt;
1497: else
1498: ben_manage_life_events.fonm := 'N';
1499: ben_manage_life_events.g_fonm_cvg_strt_dt := null;
1500: ben_manage_life_events.g_fonm_rt_strt_dt := null;

Line 1498: ben_manage_life_events.fonm := 'N';

1494: if l_fonm_cvg_strt_dt is not null then
1495: ben_manage_life_events.fonm := 'Y';
1496: ben_manage_life_events.g_fonm_cvg_strt_dt := l_fonm_cvg_strt_dt;
1497: else
1498: ben_manage_life_events.fonm := 'N';
1499: ben_manage_life_events.g_fonm_cvg_strt_dt := null;
1500: ben_manage_life_events.g_fonm_rt_strt_dt := null;
1501: end if;
1502: else

Line 1499: ben_manage_life_events.g_fonm_cvg_strt_dt := null;

1495: ben_manage_life_events.fonm := 'Y';
1496: ben_manage_life_events.g_fonm_cvg_strt_dt := l_fonm_cvg_strt_dt;
1497: else
1498: ben_manage_life_events.fonm := 'N';
1499: ben_manage_life_events.g_fonm_cvg_strt_dt := null;
1500: ben_manage_life_events.g_fonm_rt_strt_dt := null;
1501: end if;
1502: else
1503: if ben_manage_life_events.g_fonm_cvg_strt_dt is null and ben_manage_life_events.fonm = 'Y' then

Line 1500: ben_manage_life_events.g_fonm_rt_strt_dt := null;

1496: ben_manage_life_events.g_fonm_cvg_strt_dt := l_fonm_cvg_strt_dt;
1497: else
1498: ben_manage_life_events.fonm := 'N';
1499: ben_manage_life_events.g_fonm_cvg_strt_dt := null;
1500: ben_manage_life_events.g_fonm_rt_strt_dt := null;
1501: end if;
1502: else
1503: if ben_manage_life_events.g_fonm_cvg_strt_dt is null and ben_manage_life_events.fonm = 'Y' then
1504: open c_epe;

Line 1503: if ben_manage_life_events.g_fonm_cvg_strt_dt is null and ben_manage_life_events.fonm = 'Y' then

1499: ben_manage_life_events.g_fonm_cvg_strt_dt := null;
1500: ben_manage_life_events.g_fonm_rt_strt_dt := null;
1501: end if;
1502: else
1503: if ben_manage_life_events.g_fonm_cvg_strt_dt is null and ben_manage_life_events.fonm = 'Y' then
1504: open c_epe;
1505: fetch c_epe into l_fonm_cvg_strt_dt;
1506: close c_epe;
1507: ben_manage_life_events.g_fonm_cvg_strt_dt := l_fonm_cvg_strt_dt;

Line 1507: ben_manage_life_events.g_fonm_cvg_strt_dt := l_fonm_cvg_strt_dt;

1503: if ben_manage_life_events.g_fonm_cvg_strt_dt is null and ben_manage_life_events.fonm = 'Y' then
1504: open c_epe;
1505: fetch c_epe into l_fonm_cvg_strt_dt;
1506: close c_epe;
1507: ben_manage_life_events.g_fonm_cvg_strt_dt := l_fonm_cvg_strt_dt;
1508:
1509: end if ;
1510:
1511: end if;

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

1537: fnd_message.raise_error;
1538: end if; -- notfound
1539: close c_enrt_rt;
1540:
1541: if ben_manage_life_events.fonm = 'Y' then
1542: ben_manage_life_events.g_fonm_rt_strt_dt := nvl(p_rt_strt_dt,l_enrt_rt.rt_strt_dt);
1543: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,l_effective_date);
1544: end if;
1545:

Line 1542: ben_manage_life_events.g_fonm_rt_strt_dt := nvl(p_rt_strt_dt,l_enrt_rt.rt_strt_dt);

1538: end if; -- notfound
1539: close c_enrt_rt;
1540:
1541: if ben_manage_life_events.fonm = 'Y' then
1542: ben_manage_life_events.g_fonm_rt_strt_dt := nvl(p_rt_strt_dt,l_enrt_rt.rt_strt_dt);
1543: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,l_effective_date);
1544: end if;
1545:
1546: if g_debug then

Line 1543: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,l_effective_date);

1539: close c_enrt_rt;
1540:
1541: if ben_manage_life_events.fonm = 'Y' then
1542: ben_manage_life_events.g_fonm_rt_strt_dt := nvl(p_rt_strt_dt,l_enrt_rt.rt_strt_dt);
1543: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,l_effective_date);
1544: end if;
1545:
1546: if g_debug then
1547: hr_utility.set_location(l_proc, 30);

Line 3681: ben_manage_life_events.fonm := null;

3677: if g_debug then
3678: hr_utility.set_location('Leaving:'||l_proc, 99);
3679: end if;
3680:
3681: ben_manage_life_events.fonm := null;
3682: ben_manage_life_events.g_fonm_cvg_strt_dt := null;
3683: ben_manage_life_events.g_fonm_rt_strt_dt := null;
3684: --
3685: -- Set OUT parameters

Line 3682: ben_manage_life_events.g_fonm_cvg_strt_dt := null;

3678: hr_utility.set_location('Leaving:'||l_proc, 99);
3679: end if;
3680:
3681: ben_manage_life_events.fonm := null;
3682: ben_manage_life_events.g_fonm_cvg_strt_dt := null;
3683: ben_manage_life_events.g_fonm_rt_strt_dt := null;
3684: --
3685: -- Set OUT parameters
3686: --

Line 3683: ben_manage_life_events.g_fonm_rt_strt_dt := null;

3679: end if;
3680:
3681: ben_manage_life_events.fonm := null;
3682: ben_manage_life_events.g_fonm_cvg_strt_dt := null;
3683: ben_manage_life_events.g_fonm_rt_strt_dt := null;
3684: --
3685: -- Set OUT parameters
3686: --
3687: p_prv_rt_val := l_rt_val;

Line 4754: ben_manage_life_events.fonm := 'Y';

4750: close c_epe ;
4751:
4752: if l_fonm_cvg_strt_dt is not null then
4753: l_fonm_flag := 'Y' ;
4754: ben_manage_life_events.fonm := 'Y';
4755: ben_manage_life_events.g_fonm_cvg_strt_dt := l_fonm_cvg_strt_dt;
4756: else
4757: l_fonm_flag := 'N' ;
4758: ben_manage_life_events.fonm := 'N';

Line 4755: ben_manage_life_events.g_fonm_cvg_strt_dt := l_fonm_cvg_strt_dt;

4751:
4752: if l_fonm_cvg_strt_dt is not null then
4753: l_fonm_flag := 'Y' ;
4754: ben_manage_life_events.fonm := 'Y';
4755: ben_manage_life_events.g_fonm_cvg_strt_dt := l_fonm_cvg_strt_dt;
4756: else
4757: l_fonm_flag := 'N' ;
4758: ben_manage_life_events.fonm := 'N';
4759: ben_manage_life_events.g_fonm_cvg_strt_dt := null ;

Line 4758: ben_manage_life_events.fonm := 'N';

4754: ben_manage_life_events.fonm := 'Y';
4755: ben_manage_life_events.g_fonm_cvg_strt_dt := l_fonm_cvg_strt_dt;
4756: else
4757: l_fonm_flag := 'N' ;
4758: ben_manage_life_events.fonm := 'N';
4759: ben_manage_life_events.g_fonm_cvg_strt_dt := null ;
4760: end if ;
4761: hr_utility.set_location (' FONM ' || ben_manage_life_events.fonm , 99 ) ;
4762: hr_utility.set_location (' FONM CVG ' || ben_manage_life_events.g_fonm_cvg_strt_dt , 99 ) ;

Line 4759: ben_manage_life_events.g_fonm_cvg_strt_dt := null ;

4755: ben_manage_life_events.g_fonm_cvg_strt_dt := l_fonm_cvg_strt_dt;
4756: else
4757: l_fonm_flag := 'N' ;
4758: ben_manage_life_events.fonm := 'N';
4759: ben_manage_life_events.g_fonm_cvg_strt_dt := null ;
4760: end if ;
4761: hr_utility.set_location (' FONM ' || ben_manage_life_events.fonm , 99 ) ;
4762: hr_utility.set_location (' FONM CVG ' || ben_manage_life_events.g_fonm_cvg_strt_dt , 99 ) ;
4763:

Line 4761: hr_utility.set_location (' FONM ' || ben_manage_life_events.fonm , 99 ) ;

4757: l_fonm_flag := 'N' ;
4758: ben_manage_life_events.fonm := 'N';
4759: ben_manage_life_events.g_fonm_cvg_strt_dt := null ;
4760: end if ;
4761: hr_utility.set_location (' FONM ' || ben_manage_life_events.fonm , 99 ) ;
4762: hr_utility.set_location (' FONM CVG ' || ben_manage_life_events.g_fonm_cvg_strt_dt , 99 ) ;
4763:
4764: --
4765: -- If form code is too lazy to pass in the result id

Line 4762: hr_utility.set_location (' FONM CVG ' || ben_manage_life_events.g_fonm_cvg_strt_dt , 99 ) ;

4758: ben_manage_life_events.fonm := 'N';
4759: ben_manage_life_events.g_fonm_cvg_strt_dt := null ;
4760: end if ;
4761: hr_utility.set_location (' FONM ' || ben_manage_life_events.fonm , 99 ) ;
4762: hr_utility.set_location (' FONM CVG ' || ben_manage_life_events.g_fonm_cvg_strt_dt , 99 ) ;
4763:
4764: --
4765: -- If form code is too lazy to pass in the result id
4766: -- then get it from the choice. Note will be null if

Line 6427: ben_manage_life_events.fonm := l_fonm_flag ;

6423: );
6424: --
6425: -- after delete enrollment the fonm flag back
6426: -- when the plan replcaed the dele_enroll might have reset the fonm flag
6427: ben_manage_life_events.fonm := l_fonm_flag ;
6428: ben_manage_life_events.g_fonm_cvg_strt_dt := l_fonm_cvg_strt_dt;
6429:
6430: hr_utility.set_location (' aftr del_enrl FONM ' || ben_manage_life_events.fonm , 99 ) ;
6431: hr_utility.set_location (' FONM CVG ' || ben_manage_life_events.g_fonm_cvg_strt_dt , 99 ) ;

Line 6428: ben_manage_life_events.g_fonm_cvg_strt_dt := l_fonm_cvg_strt_dt;

6424: --
6425: -- after delete enrollment the fonm flag back
6426: -- when the plan replcaed the dele_enroll might have reset the fonm flag
6427: ben_manage_life_events.fonm := l_fonm_flag ;
6428: ben_manage_life_events.g_fonm_cvg_strt_dt := l_fonm_cvg_strt_dt;
6429:
6430: hr_utility.set_location (' aftr del_enrl FONM ' || ben_manage_life_events.fonm , 99 ) ;
6431: hr_utility.set_location (' FONM CVG ' || ben_manage_life_events.g_fonm_cvg_strt_dt , 99 ) ;
6432:

Line 6430: hr_utility.set_location (' aftr del_enrl FONM ' || ben_manage_life_events.fonm , 99 ) ;

6426: -- when the plan replcaed the dele_enroll might have reset the fonm flag
6427: ben_manage_life_events.fonm := l_fonm_flag ;
6428: ben_manage_life_events.g_fonm_cvg_strt_dt := l_fonm_cvg_strt_dt;
6429:
6430: hr_utility.set_location (' aftr del_enrl FONM ' || ben_manage_life_events.fonm , 99 ) ;
6431: hr_utility.set_location (' FONM CVG ' || ben_manage_life_events.g_fonm_cvg_strt_dt , 99 ) ;
6432:
6433:
6434: end if;

Line 6431: hr_utility.set_location (' FONM CVG ' || ben_manage_life_events.g_fonm_cvg_strt_dt , 99 ) ;

6427: ben_manage_life_events.fonm := l_fonm_flag ;
6428: ben_manage_life_events.g_fonm_cvg_strt_dt := l_fonm_cvg_strt_dt;
6429:
6430: hr_utility.set_location (' aftr del_enrl FONM ' || ben_manage_life_events.fonm , 99 ) ;
6431: hr_utility.set_location (' FONM CVG ' || ben_manage_life_events.g_fonm_cvg_strt_dt , 99 ) ;
6432:
6433:
6434: end if;
6435: --