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_SSPNDD_ENROLLMENT dependencies on BEN_ENRT_BNFT

Line 549: from ben_enrt_bnft enb

545: pil.per_in_ler_stat_cd is null);
546: --
547: cursor c_epe_from_enb(v_enrt_bnft_id number) is
548: select enb.*
549: from ben_enrt_bnft enb
550: where enb.enrt_bnft_id = v_enrt_bnft_id ;
551: --
552: l_epe_from_enb c_epe_from_enb%ROWTYPE;
553: --

Line 558: from ben_enrt_bnft enb

554: cursor c_enb_rng(v_epe_id number,
555: -- v_enrt_bnft_id number,
556: v_bnft_amt number) is
557: select enb.*
558: from ben_enrt_bnft enb
559: where -- enb.enrt_bnft_id = v_enrt_bnft_id
560: enb.val = p_interim_bnft_amt
561: and enb.elig_per_elctbl_chc_id = v_epe_id ;
562: --

Line 567: from ben_enrt_bnft enb

563: l_dummy varchar2(30);
564: --
565: cursor c_enb(v_elig_per_elctbl_chc_id number) is
566: select enb.*
567: from ben_enrt_bnft enb
568: where enb.elig_per_elctbl_chc_id = v_elig_per_elctbl_chc_id
569: and enb.MX_WO_CTFN_FLAG = 'N' ;
570: --
571: cursor c_enb_entr(v_elig_per_elctbl_chc_id number) is

Line 573: from ben_enrt_bnft enb

569: and enb.MX_WO_CTFN_FLAG = 'N' ;
570: --
571: cursor c_enb_entr(v_elig_per_elctbl_chc_id number) is
572: select enb.*
573: from ben_enrt_bnft enb
574: where enb.elig_per_elctbl_chc_id = v_elig_per_elctbl_chc_id
575: and enb.MX_WO_CTFN_FLAG = 'Y' ;
576: --
577: /*

Line 592: from ben_enrt_bnft

588: */
589: --
590: cursor c_enbcount(v_elig_per_elctbl_chc_id number) is
591: select count(*)
592: from ben_enrt_bnft
593: where elig_per_elctbl_chc_id = v_elig_per_elctbl_chc_id
594: and ordr_num >= 0 ; --This will exclude the records being create for SAME case
595: --which are created with -1
596: --

Line 1221: ben_enrt_bnft enb

1217: enb.enrt_bnft_id
1218: from ben_per_in_ler pil,
1219: ben_elig_per_elctbl_chc epe,
1220: ben_pl_f pl,
1221: ben_enrt_bnft enb
1222: where
1223: pil.business_group_id=p_business_group_id and
1224: pil.person_id=p_person_id and
1225: --pil.per_in_ler_stat_cd='STRTD' and

Line 1258: ben_enrt_bnft enb

1254: enb.enrt_bnft_id
1255: from ben_per_in_ler pil,
1256: ben_elig_per_elctbl_chc epe,
1257: ben_pl_f pl,
1258: ben_enrt_bnft enb
1259: where
1260: pil.business_group_id=p_business_group_id and
1261: pil.person_id=p_person_id and
1262: --pil.per_in_ler_stat_cd='STRTD' and

Line 1300: ben_enrt_bnft enb

1296: enb.enrt_bnft_id
1297: from ben_per_in_ler pil,
1298: ben_elig_per_elctbl_chc epe,
1299: ben_pl_f pl,
1300: ben_enrt_bnft enb
1301: where
1302: pil.business_group_id=p_business_group_id and
1303: pil.person_id=p_person_id and
1304: --pil.per_in_ler_stat_cd='STRTD' and

Line 1343: ben_enrt_bnft enb

1339: enb.enrt_bnft_id
1340: from ben_per_in_ler pil,
1341: ben_elig_per_elctbl_chc epe,
1342: ben_pl_f pl,
1343: ben_enrt_bnft enb
1344: where
1345: pil.business_group_id=p_business_group_id and
1346: pil.person_id=p_person_id and
1347: --pil.per_in_ler_stat_cd='STRTD' and

Line 1382: ben_enrt_bnft eb

1378: select epe.elig_per_elctbl_chc_id, eb.enrt_bnft_id
1379: from ben_per_in_ler pil,
1380: ben_elig_per_elctbl_chc epe,
1381: ben_pl_f pl,
1382: ben_enrt_bnft eb
1383: where
1384: pil.business_group_id=p_business_group_id and
1385: pil.person_id=p_person_id and
1386: --pil.per_in_ler_stat_cd='STRTD' and

Line 1419: ben_enrt_bnft enb,

1415: select epe.elig_per_elctbl_chc_id,
1416: enb.enrt_bnft_id
1417: from ben_per_in_ler pil,
1418: ben_elig_per_elctbl_chc epe,
1419: ben_enrt_bnft enb,
1420: ben_pl_f pl
1421: where pil.business_group_id=p_business_group_id and
1422: pil.person_id=p_person_id and
1423: --pil.per_in_ler_stat_cd='STRTD' and

Line 1455: ben_enrt_bnft eb

1451: eb.enrt_bnft_id
1452: from ben_per_in_ler pil,
1453: ben_elig_per_elctbl_chc epe,
1454: ben_pl_f pl,
1455: ben_enrt_bnft eb
1456: where
1457: pil.business_group_id=p_business_group_id and
1458: pil.person_id=p_person_id and
1459: --pil.per_in_ler_stat_cd='STRTD' and

Line 1493: ben_enrt_bnft eb,

1489: select epe.elig_per_elctbl_chc_id,
1490: eb.enrt_bnft_id
1491: from ben_per_in_ler pil,
1492: ben_elig_per_elctbl_chc epe,
1493: ben_enrt_bnft eb,
1494: ben_pl_f pl
1495: where
1496: pil.business_group_id=p_business_group_id and
1497: pil.person_id=p_person_id and

Line 1532: ben_enrt_bnft enb,

1528: select epe.elig_per_elctbl_chc_id,
1529: enb.enrt_bnft_id
1530: from ben_per_in_ler pil,
1531: ben_elig_per_elctbl_chc epe,
1532: ben_enrt_bnft enb,
1533: ben_pl_f pl
1534: where
1535: pil.business_group_id=p_business_group_id and
1536: pil.person_id=p_person_id and

Line 1573: ben_enrt_bnft eb,

1569: select epe.elig_per_elctbl_chc_id,
1570: eb.enrt_bnft_id
1571: from ben_per_in_ler pil,
1572: ben_elig_per_elctbl_chc epe,
1573: ben_enrt_bnft eb,
1574: ben_pl_f pl
1575: where
1576: pil.business_group_id=p_business_group_id and
1577: pil.person_id=p_person_id and

Line 1617: from ben_enrt_bnft enb1,

1613: cursor c_bnft is
1614: select nvl(enb2.mn_val, 0) min_bnft_amt,
1615: nvl(enb2.dflt_val, 0) dflt_bnft_amt, -- Bug 1886183
1616: enb1.enrt_bnft_id
1617: from ben_enrt_bnft enb1,
1618: ben_enrt_bnft enb2
1619: where enb1.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
1620: and enb1.cvg_mlt_cd = 'FLFX'
1621: and enb2.elig_per_elctbl_chc_id = enb1.elig_per_elctbl_chc_id

Line 1618: ben_enrt_bnft enb2

1614: select nvl(enb2.mn_val, 0) min_bnft_amt,
1615: nvl(enb2.dflt_val, 0) dflt_bnft_amt, -- Bug 1886183
1616: enb1.enrt_bnft_id
1617: from ben_enrt_bnft enb1,
1618: ben_enrt_bnft enb2
1619: where enb1.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
1620: and enb1.cvg_mlt_cd = 'FLFX'
1621: and enb2.elig_per_elctbl_chc_id = enb1.elig_per_elctbl_chc_id
1622: and enb2.entr_val_at_enrt_flag = 'Y'

Line 1638: from ben_enrt_bnft enb1,

1634: --
1635: cursor c_bnft is
1636: select enb1.val bnft_amt,
1637: enb1.enrt_bnft_id
1638: from ben_enrt_bnft enb1,
1639: ben_enrt_bnft enb2,
1640: ben_pl_f pl,
1641: ben_elig_per_elctbl_chc epe --Bug 3042379 Dont select 'R' cases
1642: --to make it consistent with other

Line 1639: ben_enrt_bnft enb2,

1635: cursor c_bnft is
1636: select enb1.val bnft_amt,
1637: enb1.enrt_bnft_id
1638: from ben_enrt_bnft enb1,
1639: ben_enrt_bnft enb2,
1640: ben_pl_f pl,
1641: ben_elig_per_elctbl_chc epe --Bug 3042379 Dont select 'R' cases
1642: --to make it consistent with other
1643: --interim cursors.

Line 1668: from ben_enrt_bnft enb1,

1664: --
1665: cursor c_dflt_bnft is
1666: select enb1.val bnft_amt,
1667: enb1.enrt_bnft_id
1668: from ben_enrt_bnft enb1,
1669: ben_enrt_bnft enb2,
1670: ben_pl_f pl,
1671: ben_elig_per_elctbl_chc epe --Bug 3042379 Dont select 'R' cases
1672: --to make it consistent with other

Line 1669: ben_enrt_bnft enb2,

1665: cursor c_dflt_bnft is
1666: select enb1.val bnft_amt,
1667: enb1.enrt_bnft_id
1668: from ben_enrt_bnft enb1,
1669: ben_enrt_bnft enb2,
1670: ben_pl_f pl,
1671: ben_elig_per_elctbl_chc epe --Bug 3042379 Dont select 'R' cases
1672: --to make it consistent with other
1673: --interim cursors.

Line 1698: from ben_enrt_bnft enb

1694: --
1695: cursor c_cur_bnft(p_elig_per_elctbl_chc_id in number) is
1696: select enb.val bnft_amt,
1697: enb.enrt_bnft_id
1698: from ben_enrt_bnft enb
1699: where enb.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
1700: ----Bug : 7195598
1701: and enb.ordr_num in (-1,1)
1702: ---Bug 7195598

Line 1826: from ben_enrt_bnft enb

1822: c_bnft_amt number,
1823: c_elig_per_elctbl_chc_id number ) is
1824: select enb.enrt_bnft_id,
1825: enb.val bnft_amt
1826: from ben_enrt_bnft enb
1827: where enb.ordr_num = c_ordr_num
1828: --enb.val = c_bnft_amt
1829: and enb.entr_val_at_enrt_flag = 'N'
1830: and enb.elig_per_elctbl_chc_id = c_elig_per_elctbl_chc_id ;

Line 1838: from ben_enrt_bnft enb

1834: c_bnft_amt number,
1835: c_elig_per_elctbl_chc_id number ) is
1836: select enb.enrt_bnft_id,
1837: enb.val bnft_amt
1838: from ben_enrt_bnft enb
1839: where --enb.ordr_num = c_ordr_num
1840: enb.val = c_bnft_amt
1841: and enb.entr_val_at_enrt_flag = 'N'
1842: and enb.mx_wo_ctfn_flag = 'Y'

Line 2537: ,ben_enrt_bnft enb

2533: select ecr.enrt_rt_id
2534: ,ecr.dflt_val
2535: ,ecr.ANN_DFLT_VAL
2536: from ben_enrt_rt ecr
2537: ,ben_enrt_bnft enb
2538: where enb.enrt_bnft_id = ecr.enrt_bnft_id
2539: and ecr.business_group_id = p_business_group_id
2540: and enb.business_group_id = p_business_group_id
2541: and enb.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id

Line 2548: from ben_enrt_bnft

2544: ;
2545: --
2546: cursor c_bnft is
2547: select enrt_bnft_id, val
2548: from ben_enrt_bnft
2549: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
2550: and business_group_id=p_business_group_id
2551: -- and dflt_flag = 'Y'
2552: and (enrt_bnft_id=p_enrt_bnft_id

Line 2560: l_bnft_amt ben_enrt_bnft.val%type;

2556: type enrt_id_table is table of c_rt%rowtype index by binary_integer;
2557: l_proc varchar2(80) := g_package || '.process_interim';
2558: l_rt enrt_id_table;
2559: l_tot_rt number(5) := 0;
2560: l_bnft_amt ben_enrt_bnft.val%type;
2561: l_bnft_id ben_enrt_bnft.enrt_bnft_id%type;
2562: l_suspend_flag varchar2(30);
2563: l_prtt_enrt_interim_id number(15);
2564: l_datetrack_mode varchar2(30);

Line 2561: l_bnft_id ben_enrt_bnft.enrt_bnft_id%type;

2557: l_proc varchar2(80) := g_package || '.process_interim';
2558: l_rt enrt_id_table;
2559: l_tot_rt number(5) := 0;
2560: l_bnft_amt ben_enrt_bnft.val%type;
2561: l_bnft_id ben_enrt_bnft.enrt_bnft_id%type;
2562: l_suspend_flag varchar2(30);
2563: l_prtt_enrt_interim_id number(15);
2564: l_datetrack_mode varchar2(30);
2565: l_effective_start_date date;

Line 2911: from ben_enrt_bnft enb

2907: cursor c_current_bnft (p_prtt_enrt_rslt_id number,
2908: p_elig_per_elctbl_chc_id number,
2909: p_bnft_ordr_num number ) is
2910: select enb.enrt_bnft_id
2911: from ben_enrt_bnft enb
2912: where enb.prtt_enrt_rslt_id=p_prtt_enrt_rslt_id
2913: and enb.elig_per_elctbl_chc_id=p_elig_per_elctbl_chc_id
2914: and enb.business_group_id=p_business_group_id
2915: union -- To get this when the enb is not update with the pen_id

Line 2919: from ben_enrt_bnft enb

2915: union -- To get this when the enb is not update with the pen_id
2916: -- This happens in the flex enrollment if the certifications is called
2917: -- from flex routine /*ENH*/
2918: select enb.enrt_bnft_id
2919: from ben_enrt_bnft enb
2920: where
2921: enb.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
2922: and enb.ordr_num = p_bnft_ordr_num ;
2923:

Line 3779: from ben_enrt_bnft enb

3775: cursor c_enb(p_prtt_enrt_rslt_id number,
3776: p_elig_per_elctbl_chc_id number) is
3777: select enb.enrt_bnft_id,
3778: enb.object_version_number
3779: from ben_enrt_bnft enb
3780: where enb.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
3781: and enb.prtt_enrt_rslt_id is not null
3782: and enb.prtt_enrt_rslt_id <> p_prtt_enrt_rslt_id ;
3783: --

Line 3791: ben_enrt_bnft enb

3787: p_effective_date date) is
3788: select enb.enrt_bnft_id,
3789: enb.object_version_number
3790: from ben_prtt_enrt_rslt_f pen,
3791: ben_enrt_bnft enb
3792: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
3793: and p_effective_date between pen.effective_start_date and pen.effective_end_date
3794: and pen.bnft_ordr_num = enb.ordr_num
3795: and enb.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id

Line 4513: ben_enrt_bnft_api.update_enrt_bnft

4509: -- Need to clean the enb records for pen_id
4510: --
4511: for l_enb in c_enb(p_prtt_enrt_rslt_id,l_elig_per_elctbl_chc_id) loop
4512: --
4513: ben_enrt_bnft_api.update_enrt_bnft
4514: (p_enrt_bnft_id => l_enb.enrt_bnft_id
4515: ,p_effective_date => p_effective_date
4516: ,p_object_version_number => l_enb.object_version_number
4517: ,p_business_group_id => p_business_group_id