APPS.BEN_MANAGE_LIFE_EVENTS dependencies on BEN_OIPL_F

Line 1371: from ben_oipl_f oipl

1367: abr.effective_start_date and abr.effective_end_date
1368: and (abr.pl_id = p_pl_id or
1369: abr.oipl_id in
1370: (select oipl.oipl_id
1371: from ben_oipl_f oipl
1372: where oipl.pl_id = p_pl_id
1373: and oipl.business_group_id = p_business_group_id
1374: and nvl(p_lf_evt_ocrd_dt,p_effective_date) between
1375: oipl.effective_start_date and oipl.effective_end_date

Line 1392: from ben_oipl_f oipl

1388: abr1.effective_start_date and abr1.effective_end_date
1389: and (abr1.pl_id = p_pl_id or
1390: abr1.oipl_id in
1391: (select oipl.oipl_id
1392: from ben_oipl_f oipl
1393: where oipl.pl_id = p_pl_id
1394: and oipl.business_group_id = p_business_group_id
1395: and nvl(p_lf_evt_ocrd_dt,p_effective_date) between
1396: oipl.effective_start_date and oipl.effective_end_date

Line 1420: from ben_oipl_f oipl

1416: abr1.effective_start_date and abr1.effective_end_date
1417: and (abr1.pl_id = p_pl_id or
1418: abr1.oipl_id in
1419: (select oipl.oipl_id
1420: from ben_oipl_f oipl
1421: where oipl.pl_id = p_pl_id
1422: and oipl.business_group_id = p_business_group_id
1423: and nvl(p_lf_evt_ocrd_dt,p_effective_date) between
1424: oipl.effective_start_date and oipl.effective_end_date

Line 1452: from ben_oipl_f oipl

1448: abr1.effective_start_date and abr1.effective_end_date
1449: and (abr1.pl_id = p_pl_id or
1450: abr1.oipl_id in
1451: (select oipl.oipl_id
1452: from ben_oipl_f oipl
1453: where oipl.pl_id = p_pl_id
1454: and oipl.business_group_id = p_business_group_id
1455: and nvl(p_lf_evt_ocrd_dt,p_effective_date) between
1456: oipl.effective_start_date and oipl.effective_end_date

Line 1479: from ben_oipl_f oipl

1475: and nvl(p_lf_evt_ocrd_dt,p_effective_date) between
1476: opt.effective_start_date and opt.effective_end_date
1477: and opt.opt_id in
1478: (select oipl.opt_id
1479: from ben_oipl_f oipl
1480: where oipl.pl_id = p_pl_id
1481: and oipl.business_group_id = p_business_group_id
1482: and nvl(p_lf_evt_ocrd_dt,p_effective_date) between
1483: oipl.effective_start_date and oipl.effective_end_date);

Line 1499: from ben_oipl_f oipl

1495: and pt.opt_typ_cd = 'CWB'
1496: and (ccm.pl_id = pl.pl_id or
1497: ccm.oipl_id in
1498: (select oipl.oipl_id
1499: from ben_oipl_f oipl
1500: where oipl.pl_id = pl.pl_id
1501: and oipl.business_group_id = p_business_group_id
1502: and nvl(p_lf_evt_ocrd_dt,p_effective_date) between
1503: oipl.effective_start_date and oipl.effective_end_date

Line 1523: from ben_oipl_f oipl

1519:
1520: -- to find wheether there is any option
1521: cursor c10 is
1522: select 'x' found
1523: from ben_oipl_f oipl
1524: where oipl.pl_id = p_pl_id
1525: and oipl.business_group_id = p_business_group_id
1526: and nvl(p_lf_evt_ocrd_dt,p_effective_date) between
1527: oipl.effective_start_date and oipl.effective_end_date ;

Line 4893: from ben_oipl_f oipl

4889: pl.effective_end_date;
4890:
4891: cursor c_pln_opt is
4892: select 'x'
4893: from ben_oipl_f oipl
4894: where oipl.pl_id = l_pl_id
4895: and p_effective_date between oipl.effective_start_date and
4896: oipl.effective_end_date;
4897:

Line 8362: l_oipl_rec ben_oipl_f%rowtype;

8358: l_package varchar2(80);
8359: l_comp_object_name varchar2(80);
8360: l_pgm_rec ben_pgm_f%rowtype;
8361: l_pl_rec ben_pl_f%rowtype;
8362: l_oipl_rec ben_oipl_f%rowtype;
8363: l_opt_rec ben_opt_f%rowtype;
8364: l_plip_rec ben_plip_f%rowtype;
8365: l_ptip_rec ben_ptip_f%rowtype;
8366: --

Line 10105: from ben_oiplip_f opp, ben_oipl_f cop

10101: --
10102: cursor c_get_oiplip_opt_id (cv_oipl_id number,
10103: cv_plip_id number) is
10104: select opp.oiplip_id, opt_id
10105: from ben_oiplip_f opp, ben_oipl_f cop
10106: where opp.oipl_id = cv_oipl_id
10107: and opp.plip_id = cv_plip_id
10108: and p_effective_date between opp.effective_start_date and opp.effective_end_date
10109: and cop.oipl_id = opp.oipl_id